update a "sub" table from a "Main" form

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi,

I have a "main" table and a "sub" table. The main table
has lots of fields and the "sub" table has two fields; the
main table record id and one other data field) The tables
have a one to many relationship. I have a "main" FORM
with all the main table fields on it and I would like to
display the related "sub" table field and to be able to
update the "sub" table from the "main" FORM. Is this
possible and if so how. I would also like to only allow
values from a third table to added to the "sub" table.

Thanks very much....

Phil
..
 
Create a form to display data from the sub-table. Hide the foreign key so that the form only shows one field. Use a combo to display the single field values. The wizard will build the combo for you. Choose the option that lets you select rows from a table or query. Set the limit to list property to yes. Add this form to the main form. Make sure the master/child links are properly set.
 
Thanks Pat,

Sorry, I'm not clear on what you mean. Is my sub-table
form to have two fields on it? One to show the sub-table
entries for the matching main table id, and a combo which
will allow me to select additional entries to add to my
sub-table? That's what I tried and I could not get
anything to work. More help would be appreciated.

Thanks again,
Phil
-----Original Message-----
Create a form to display data from the sub-table. Hide
Click to expand...
the foreign key so that the form only shows one field.
Use a combo to display the single field values. The
wizard will build the combo for you. Choose the option
that lets you select rows from a table or query. Set the
limit to list property to yes. Add this form to the main
form. Make sure the master/child links are properly set.
 
Back
Top