Link between form and tables

  • Thread starter Thread starter Box 666
  • Start date Start date
B

Box 666

I have two tables:- "A" is preloaded with bulk data, each time relating
customer data is loaded it is given the same ref no. Table "B" is to be a
summary table linked by ref no. So (say) five items on "A" all with ref no
66 are to be sumaries on table "B" under the ref no 66. The ref no being the
join between the 2 tables.

I have created a query from "A" and "B" using all fields from both tables. I
have then based a input form on that query. However it will not let me fill
/ populate any fields from table "B"

I assume this is because "B" is empty and therefore there are no join fields
that are equal.

So how do I populate "B"

Bob
 
Instead of combining the tables into a query, I'd suggest a form - subform
design.

- Turtle
 
Back
Top