R
Rominall
I have 3 tables and want the user to use a form to input information.
Thinking about using a sub-form but am having trouble getting the 'main'
table to force through the ID.
Main table -Fields - Primary ID (StrategyID), Description, Person
2nd table - Fields - MainID (this must match the main PrimaryID selected),
Date, NumberField1, NumberField2
3rd table - Fields - MainID (this must match the main PrimaryID selected),
Date, Description1
So the process would be for the user to open the 'main' form, select the
right Strategy and then click on either table 2 or table 3 which then should
populate with the Strategy ID but not be changeable.
I do not want the user on the 2nd or 3rd form to be able to change that
MainID but I want it visible.
I can get the forms set up, but when I add the MainID as a text box the user
can change it. Do I need to use something else? Or is there some setting
that I'm missing?
Thinking about using a sub-form but am having trouble getting the 'main'
table to force through the ID.
Main table -Fields - Primary ID (StrategyID), Description, Person
2nd table - Fields - MainID (this must match the main PrimaryID selected),
Date, NumberField1, NumberField2
3rd table - Fields - MainID (this must match the main PrimaryID selected),
Date, Description1
So the process would be for the user to open the 'main' form, select the
right Strategy and then click on either table 2 or table 3 which then should
populate with the Strategy ID but not be changeable.
I do not want the user on the 2nd or 3rd form to be able to change that
MainID but I want it visible.
I can get the forms set up, but when I add the MainID as a text box the user
can change it. Do I need to use something else? Or is there some setting
that I'm missing?