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

Junction tables

P: n/a
Hi5
Hi ,

I have tried the junctiontion table it dosen' t seem to have the
capablity to hold more thean one category per client.thereofre I have
tried making it with as many as possible culomns to overcome the
limitation of the three column table,but looks allright but seems that
access has problems with it?

it just loses the relationships and also, when I try to get a simple
query from the system which must looklike the original spreadsheet it
seems that access multiplies the number of rows by the number of
culomns in the client category.

Is there any solution?

Many thanks

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You have posted this before, and got quite a few answers. If some mail
machine reposted this, never mind. If you did it yourself, what can I say?
Is there *anything* in the answers that provides you with a hook to proceed?

Hi5 wrote:
Hi ,

I have tried the junctiontion table it dosen' t seem to have the
capablity to hold more thean one category per client.thereofre I have
tried making it with as many as possible culomns to overcome the
limitation of the three column table,but looks allright but seems that
access has problems with it?

it just loses the relationships and also, when I try to get a simple
query from the system which must looklike the original spreadsheet it
seems that access multiplies the number of rows by the number of
culomns in the client category.

Is there any solution?

Many thanks


--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.