Forum Discussion
KrissyKrissy
10 years agoQrew Cadet
Thank you! I'm almost there..... I'm running into one problem. I went with the high tech scenario option 1 - here is my formula:
URLRoot() & "db/" & Dbid() & "?act=API_GenAddRecordForm"
& "&_fid_85=" & URLEncode([PO # (on PO form) - Lookup])
& "&_fid_23=" & URLEncode([Item Number (on ITEMS form) - Lookup])
& "&_fid_6=" & [Inspector]
Field 23 is not populating. It's a look up field that relates the inspection back to the item being inspected. Any idea why that isn't populating? FID 85 is also a look up field and that one is populating correctly. Could it have something to do with the relationship between those 2 fields?
URLRoot() & "db/" & Dbid() & "?act=API_GenAddRecordForm"
& "&_fid_85=" & URLEncode([PO # (on PO form) - Lookup])
& "&_fid_23=" & URLEncode([Item Number (on ITEMS form) - Lookup])
& "&_fid_6=" & [Inspector]
Field 23 is not populating. It's a look up field that relates the inspection back to the item being inspected. Any idea why that isn't populating? FID 85 is also a look up field and that one is populating correctly. Could it have something to do with the relationship between those 2 fields?