Happy New Year to you all..
Now for the problem
I have two tables, Cat1 and Items.
Cat1 have three colums,
cat1_id
cat1_name
cat1_desc

Items have various colums, but does also contain
cat1_id
cat1_name
cat_desc

In an insert form for items the client can choose which cat1 item, I have it displayed as a dynamic drop/list from cat1 table, the client sees the cat1_name details but the form puts the cat1_id details into items table, cat1_id colum.
Thats all working and what I want.
The problem is that the items table now only contains the cat1_id. How can I get the form to put the cat1_name and cat1_desc from cat1 table into items table from just one selection ?
I hope this make sence to someone out there
Many thanks in advance
CK

Forgive me if i'm wrong but ive just come in from my new yrs party <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Sounds like you got no relationship set up in your db tables.

Regards,
Dave

UD4 | Flash 5/MX | Studio MX | SQL | Access | ASP/VBScript | XP-Pro

Have tried it with relationship but still can't figure it out

Dave
Solved the problem, had made the join type wrong. Changed to One2Many and all worked fine.
Would I be able to use the same process but at the form insert level
i.e. input from client into form inserting item table would take data from cat table and place it in item table ?
Many Tanks
ck

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> Changed to One2Many and all worked fine<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

So it was a relationship problem <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> Not bad for a blind drunk guess eh.



Regards,
Dave

UD4 | Flash 5/MX | Studio MX | SQL | Access | ASP/VBScript | XP-Pro