B
Banjo
Hi
I´m really stuck - and can´t see what i´m doing wrong.
I have 3 tables - Customer Details (Customer ID is the PK) containing
address etc. Unit Details (Unit ID is the PK) - which includes Description,
Price and Unit Code. I´ve then created another table that is called
Reservations and I want to be able to pick a UNIT and for it to then draw
down the description, and price. I dragged Customer ID into this table, and
also Unit ID and created one-to-many relationships with enforced referential
integrity. I´ve tried making Unit Code field a lookup, but it doesnt
autofill the rest of the row.
This is where I now get stuck. I´ve tried to create a subform in my
customer form, that uses the Reservations table, but the rows just won´t
autofill. I´ve tried creating various queries, but these arne´t working.
Really frustrated, I can´t see what i´ve done wrong, and i´ve been comparing
to the Northwind sample and have tried everything!!
I´m really stuck - and can´t see what i´m doing wrong.
I have 3 tables - Customer Details (Customer ID is the PK) containing
address etc. Unit Details (Unit ID is the PK) - which includes Description,
Price and Unit Code. I´ve then created another table that is called
Reservations and I want to be able to pick a UNIT and for it to then draw
down the description, and price. I dragged Customer ID into this table, and
also Unit ID and created one-to-many relationships with enforced referential
integrity. I´ve tried making Unit Code field a lookup, but it doesnt
autofill the rest of the row.
This is where I now get stuck. I´ve tried to create a subform in my
customer form, that uses the Reservations table, but the rows just won´t
autofill. I´ve tried creating various queries, but these arne´t working.
Really frustrated, I can´t see what i´ve done wrong, and i´ve been comparing
to the Northwind sample and have tried everything!!