Table Relationships

Question

I have a table named Projects.&nbsp; There are two child tables named Options and PO's.&nbsp; 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.&nbsp; The trouble I'm having is that when I click "Add Option" from the Add PO form, the "Add Option" form doesn't relate (auto-populate) the Project that the PO is related to, the related project field is blank and I have to manually type it in.&nbsp; I can't figure out how to relate the tables and fields so that the "Add Option" form knows which Project it's creating records for.Any suggestions are appreciated.------------------------------Aaron Lavender------------------------------

markshnier__you · Answer

Can you clarify the relations you have? &nbsp;Is options a child of POs as well as Projects?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

aaronlavender · Answer

Hey Mark, thanks for replying.&nbsp; I do not have a relationship created between PO's and Options (Job Options).------------------------------Aaron Lavender------------------------------

markshnier__you · Answer

Try this
try this as a button on Purchase Orders &nbsp;
URLRoot() &amp; "db/" &amp; [_DBID_OPTIONS] &amp; "?act=API_GenAddRecordForm&amp;_fid_99=" &amp; [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 &nbsp;
​------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

Table Relationships