Displaying data from 3 tables in unbound form

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I need to display and be able to update data from 3
tables in an unbound form. I create a pop-up form to set
criteria for a parameter query and then use the query to
create a recordset that consists of data from the
customer and address tables. I display this data in
unbound text boxes on a form. I then need to display
categories of a customer on the same form, there can be
many categories for a given customer. I tried to display
this data in a subform (with my category table as the
source), but Access will not allow you to use
parent/child field ids for a subform within an unbound
form. How can I coordinate displaying the correct
categories for a customer using an unbound form? Is there
an example I can look at? Thanks.
 
Gary said:
I need to display and be able to update data from 3
tables in an unbound form. I create a pop-up form to set
criteria for a parameter query and then use the query to
create a recordset that consists of data from the
customer and address tables. I display this data in
unbound text boxes on a form. I then need to display
categories of a customer on the same form, there can be
many categories for a given customer. I tried to display
this data in a subform (with my category table as the
source), but Access will not allow you to use
parent/child field ids for a subform within an unbound
form. How can I coordinate displaying the correct
categories for a customer using an unbound form?
Click to expand...


If the subform is bound, then you can use a main form
textbox for the Link Master property.
 
Back
Top