ContributionsMost RecentMost LikesSolutionsRe: Table RelationshipsHey Mark, thanks for replying. I do not have a relationship created between PO's and Options (Job Options). ------------------------------ Aaron Lavender ------------------------------ Table RelationshipsI 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. 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. 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 ------------------------------ Re: Report Link embedded within in form with a report from same tableHey, hoping you might still respond to this thread. I created the field to match on but it doesn't display in the list of fields to match to. What am I missing? ------------------------------ Aaron Lavender ------------------------------