Auto Fill
I don't know how to explain some of this so please bear with me. I inherited this app from someone else who is no longer with the company, I'll call them X.
Some background, all our bids are assigned a Project # which is the Record ID of the Bid record in our Bid Table. That number then follows the project thru several tables to completion and is the unique identifier in projects that can have similar sounding Project Names. We may send a bid to multiple different companies and may have several different buyouts associated with each bid.
X created a table which combines two other tables so that we can assign multiple companies to a single bid
(Bid--> Table Y <-- Company)
and created a button on the Bid form to "Assign Bid Company" that takes one to the form in Table Y to assign a record of the Bid Company. A report on the Bid Form then shows all companies we send bids to for that project. It works great.
I created a table which combines two other tables so that we can assign multiple buyouts to a single bid
(Bid --> Table Z <-- Buyouts)
and created a button on the Bid form to "Add Buyout" that takes one to the form in Table Z that links a buyout to the Bid and a report that shows all the buyouts associated with that project. Again it works.
Here's my issue... When X created their button and link to Table Y the Project # field auto-populates, however, the button and link to Table Z, while it has a Project # field, doesn't auto-populate. I have compared the Forms, the Field Properties, the Relationships, Lookup options and everything else I could think of to try and figure out how X got the Project # field to auto-populate but cannot figure it out. Everything appears to be the same (other than the obvious Table Y vrs. Table Z).
Please make me feel stupid and tell me it is something incredibly simple that I am overlooking. Or just tell me how I can auto-populate the Project # field in the Table Z form!
------------------------------
Brianne Jacobsen
------------------------------
Some background, all our bids are assigned a Project # which is the Record ID of the Bid record in our Bid Table. That number then follows the project thru several tables to completion and is the unique identifier in projects that can have similar sounding Project Names. We may send a bid to multiple different companies and may have several different buyouts associated with each bid.
X created a table which combines two other tables so that we can assign multiple companies to a single bid
(Bid--> Table Y <-- Company)
and created a button on the Bid form to "Assign Bid Company" that takes one to the form in Table Y to assign a record of the Bid Company. A report on the Bid Form then shows all companies we send bids to for that project. It works great.
I created a table which combines two other tables so that we can assign multiple buyouts to a single bid
(Bid --> Table Z <-- Buyouts)
and created a button on the Bid form to "Add Buyout" that takes one to the form in Table Z that links a buyout to the Bid and a report that shows all the buyouts associated with that project. Again it works.
Here's my issue... When X created their button and link to Table Y the Project # field auto-populates, however, the button and link to Table Z, while it has a Project # field, doesn't auto-populate. I have compared the Forms, the Field Properties, the Relationships, Lookup options and everything else I could think of to try and figure out how X got the Project # field to auto-populate but cannot figure it out. Everything appears to be the same (other than the obvious Table Y vrs. Table Z).
Please make me feel stupid and tell me it is something incredibly simple that I am overlooking. Or just tell me how I can auto-populate the Project # field in the Table Z form!
------------------------------
Brianne Jacobsen
------------------------------
