Hi!
I have 2 tables: Ordertable and Nameproposals table.
1 Order can have many Nameproposals connected to it.
I have tried, in relationview in Access 2000, to pull Ordertable Primary key field, to the corresponding Nameproposals foreign key field.
But the relationship is being described as: "unknown" relationshiptype.
what can i do?
I want Ordertable to have a 1:N relationship with Nameproposal, but i cant seem to be able to get it that way. Thanks for your help.
(If its a way in t-sql to run a script to establish such a relation, no problem, i am willing to try it..)
I have 2 tables: Ordertable and Nameproposals table.
1 Order can have many Nameproposals connected to it.
I have tried, in relationview in Access 2000, to pull Ordertable Primary key field, to the corresponding Nameproposals foreign key field.
But the relationship is being described as: "unknown" relationshiptype.
what can i do?
I want Ordertable to have a 1:N relationship with Nameproposal, but i cant seem to be able to get it that way. Thanks for your help.
(If its a way in t-sql to run a script to establish such a relation, no problem, i am willing to try it..)