AnsweredAssumed Answered

Using Fields from a Related Table to Autofill Multiple Fields in the Same Table

Question asked by ChadBarnard on Nov 11, 2014
Latest reply on Nov 13, 2014 by philmodjunk

Title

Using Fields from a Related Table to Autofill Multiple Fields in the Same Table

Post

Sorry for the title, I didn't know how to sum if up.  Basically, I have a multi-tabbed table that includes information for one location.  For most of my locations, I have several gas dispensers at each location.

I have it set up so that I can select a brand, and in the next field, a drop-down menu would only have the dispenser model numbers associated w/ that brand for one dispenser.  Once the brand is selected all of the measurement fields are automatically filled out.

My question is how would I go about allowing someone to enter multiple dispenser models?  For instance, I have 3 tabs: MPD1, MPD2, MPD3.  I want to be able to select three different models on each tab, but have the information auto-fill without clashing w/ the fields in the other tabs. Since I'm pulling information from a field of a related table, I'm at a loss in how to separate the fields, so that when I select a model in MPD1, it doesn't autofill in MPD2.

Thanks for any help.

Outcomes