By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,986 Members | 2,030 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,986 IT Pros & Developers. It's quick & easy.

multipul records to a client

P: 16
I have entered this thread before but i am still having problems can anybody help?

Im running access2003 and building a simple database. The tables im interested in are:

[Client Information]
And
[Order Entry]

I have a relationship of one to many between these two tables. Client Info has the primary key and is indexed to NO Duplicates. I have also built a query that askes for the account number of the client. This then enters the Order Entry page for an order to be entered. The problem im having is access will only alow me to enter 1 order entry for that client. I need to be able to add variouse entrys to the the order entry for that customer so as to build a history of all items bought?

Not sure were im going wrong but any help would be much appreciated.

Kind regards
Brian
Oct 18 '06 #1
Share this Question
Share on Google+
4 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi

Are you sure that in your table with orders the ID of your customer has a value for the Index property set to Yes Dublicates Ok?
Oct 27 '06 #2

P: 16
Hi

Are you sure that in your table with orders the ID of your customer has a value for the Index property set to Yes Dublicates Ok?

Thanks for replying

Yes its set to Duplicate OK
Oct 30 '06 #3

PEB
Expert 100+
P: 1,418
PEB
Strange
And what is your primary key for the table Orders Entry?
Nov 4 '06 #4

NeoPa
Expert Mod 15k+
P: 31,347
You need a CustomerID and an OrderID.
The [Order Entry] PK (or at least a unique key with no duplicates) should be made up of the CustomerID AND the OrderID together in the one index.
Nov 4 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.