create a form with mutiple fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hal1968 - 30 Mar 2008 00:13 GMT

I'm pretty new to this stuff .. so bare with me . I've created some tables ,
first one consisting of manufacturer names in one feild , second one
consisting of manufacturer products , each feild related to seperate
manufacturer. Now when i create a form i can look up 1 manufacturer name but
in the products lookup in the form i can't seem to seperate the products in
relation to the manufacturer look up feild , I know it has something to do
with the way i got the query working , but that is my weak spot , unless i
need to create seperate tables based upon each manufacturer? I need a push
in the right direction , thanx in advance

Reply to this Message

Bob Quintal - 30 Mar 2008 02:41 GMT

> I'm pretty new to this stuff .. so bare with me . I've created
> some tables , first one consisting of manufacturer names in one
[quoted text clipped - 7 lines]
> manufacturer? I need a push in the right direction , thanx in
> advance

your table structure should be good, Manufacturers, with id,
manufacturerName, Address, etc.
and parts, which has the manufacturerID, the part number, and
partName, cost, weight, etc.

Your form wants to be based only on the manufacturer table, but
includes a subform based on the parts table, linked through
manufacturerID.

Signature

Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message