pass field values to an add new record form
I want to pass a value from a field in one table and click a button here and it'll generate a form to add a new record. In this button, I use the following formular: URLRoot() & "db/" & "xxxxxxxx?a=...
Forum Discussion
Is the Related Loan Application field a numeric field or a text field?
- Yes. It is numerical field.
- On the record that you were launching the button from, what value is in that field?
- We found that solution. The field id I was using was 125 but we found that it works with the ID of 122 because I heard that there are different types to that field: read-only , and editable. In this case, 125 is the READ-ONLY type and 122 is EDITABLE type. Is that correct?
- Perhaps you were trying to update a lookup field in in the table when in fact you needed to update the reference field for the relationship. Ie the field at the top right side of the relationship.
You cannot update fields which are formula fields or lookup fields. - OK, so in my case fid 125 is actually a Lookup field ID but fid 122 is the Reference field ID. Is that ture?
- So, yes, you need to update fid 122 then.
