Relationships

[Guest]

Can there be more than one relationship between two tables?
I am trying to create an order form and an invoice form but I am having
trouble allowing the user to order more then one item of stock.

 

[Guest]

I guess in a word: no

one doesn't have multiple relationships between the same two tables.....

I think you should possibly re-post the specifics of what you need to do in
a new thread in plain english....and re-start from there without looking at
it from a relationship situation just yet...

 

[John Vinson]

Can there be more than one relationship between two tables?

Yes, you can, though it's rather unusual.

I am trying to create an order form and an invoice form but I am having
trouble allowing the user to order more then one item of stock.

I suspect you're trying to do it with one FIELD per item - which is
incorrect. You need one RECORD per item instead. See the Northwind
sample database Orders form, which does exactly this. If that isn't
helpful please post back with a description of your tables and their
relationships.

John W. Vinson[MVP]