Bridge Table

[lcook1974]

Hi All,
I am having one of those days, brain appears to be scrambled.

I have 4 tables.
Department
Vendor
Items
Requistion
-Consists of all the Primary key numbers
-one field QTY
(see screen shot)

Couple of questions:
Are the relationships correct? should I change anything?

How do I get the the requistion table to populate with the ID's by using a form?

Department is an easy form.
Vendor/Items I can create a form that adds a new vendor with subform for the items. ( I can do that)

If I want to create a requistion form to Print out, I can't seem to get the form right.

Any suggestions would be great!

Larry

 

[pbaldy]

VendorID does not need to be in the requisition table, since it's in the item table. I would expect DepartmentID to be one-to-many. In a form, I'd probably have combo boxes bound to the requisition table with their row sources coming from the respective tables. Printing forms is very problematic. I'd create a report that presents the data the way you want, and print that.

 

[lcook1974]

Thanks pblady! I meant report to be printed not form. Told you my brain was scrambled. I'll give it a go...

Larry