Table Relationships
I have a table named Projects. There are two child tables named Options and PO's. From the Add PO form I'd like to be able to "Add Options" to the options table by clicking on an "Add Option" button...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you clarify the relations you have? Is options a child of POs as well as Projects?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Hey Mark, thanks for replying. I do not have a relationship created between PO's and Options (Job Options).
------------------------------
Aaron Lavender
------------------------------
------------------------------
Aaron Lavender
------------------------------
- MarkShnier__YouTry this
try this as a button on Purchase Orders
URLRoot() & "db/" & [_DBID_OPTIONS] & "?act=API_GenAddRecordForm&_fid_99=" & [Related Project]
you will need to check the Properties of the Options table to check if I guessed at the correct _DBID and also check the field ID number for the Related Purchase Order field in options and change the 99 placeholder to that field ID
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------