Hello, I'm creating a Purchasing System for multiple School Districts. I have 2 tables, Item Entry (displays all Items available for Bid. The fields in this table are Item #, Description, Unit of Measure and Item Price.) And a Joint Purchasing Entry table (this table icludes, Item #, School ID, Description, Unit of Measure, and Quantity (how may of each Item the school needs)). So far I am able to display a list of all of the Items for the Districts to see and I have a button next to each Item displayed. But I don't know how to Open the Add page from the Joint Purchasing Bids Entry table so the schools can enter the Quantity they need for the Item. Is it possible to populate the fields from the Item Entry table to the Add page when it is opened by a School ?
Hope you can make some sense of this request. Any help is greatly appreciated.