Question Stuck and Lost

[Deonh]

Hi Guys
i was wondering if any one can help me i have created a database with several tables in it 2 sets of many to many relationships in it.

My first many to many relation ship is on inventory and location and my second many to many is on customers and orders.

What i am trying to do now is put data in for the customer and then select the inventory i want to put on the order but i keep getting error messages.

I am attaching the database if any one can see where i am going wrong would be appreciated.

Using access 2007 and skill lvl is under beginner and learning

 

[pr2-eugin]

Why have you figured that it requires a Many to Many relationship? Normally One customer will have one or Many orders. I feel something funny. I have not looked at your file, but explain a little bit more !

 

[namliam]

You typicaly would have a junction table to resolve the many-to-many relationship into a many-to-one-to-many relationship to make this "work" in a relational database...

Which you do resolve this way with your stockLocationLink and Orderdetails.

Do suggest you have a read of this, before you continue:
http://www.access-programmers.co.uk/forums/showthread.php?t=225837&highlight=name+convention

 

[Deonh]

pr2-eugin

I have it as follows

customer --> Orders---->Order Detail <---Inventory--->Inventory Location<---Location

so between inventory and location there is no problem also between customer and orders there is no problem it is when i want to use link between order detail and inventory that it all goes gaga on me
hope that makes it a bit clearer

 

[namliam]

Since your database doesnt have any forms it is hard to find what is going wrong...
Or are you putting data in based on your tables? If so then that is what is going wrong.

 

[Deonh]

It has 4 forms at the moment

I have it open at the moment /panic

 

[namliam]

So it does, I must have misclicked or something?

I will have a more detailed look later on (I hope)

 

[namliam]

I think your problem is to do with the fact that you have a select statement with multiple tables in your form(s) for example in OrderDetails.

Try using a single table as a source for each form, I hope that helps you get started.

 

[Deonh]

Thanks Mailman i will give it a go on that suggestion

Never surrender never give up forward is only way to end