Relationship help

[mhemans]

I am having some difficulty with a new db that I am creating. I have created a relationship in the new DB with an existing DB. The problem that I am having is that the existing DB has two fields that I am trying to relate to 1 in the new DB. First, is it possible? Second, if it is, How do I go about it?

Thanks.

[seikos1]

Yes this should work. Setting up a DB with 2 keys to another db, just have to use an AND connection in the "Edit Relationship" dialog box.

[mhemans]

The only thing that it seems to do is create empty fields. Maybe I need to rephrase the question.

I have database A & database B. Database A has two number fields, a field for a customer name and 2 fields for parts. One of the numbers refers to one part and the other number to the other part. In Database B, I have a field for one of number fields, the customer name field, and 1 part field. Database B is one that another department is using and I want them to be able to enter a number in the number field, and have the remaining fields populated. The thing that I am having trouble with is, I can get one of them to work (entering in part #1 gives me customer name and part name). When I enter the number for part 2, I don't get anything.

Thanks