If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
create a form with mutiple fields
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 |
#2
|
|||
|
|||
create a form with mutiple fields
=?Utf-8?B?SGFsMTk2OA==?= wrote
in : 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 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. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com |
Thread Tools | |
Display Modes | |
|
|