Hello,
I've created my own table car_clients and the def files for it and sync'ed them using LinksSQL ..

First field is the client_id = Index
then second is: client_name = Primary
then many other reqular fields...

Now, I want to pull the 'client_name' from car_clients table and display it as a pull-down format when I am adding a record to another table (Category) in the same DB. Mean pre-populate a field in "Category" table from another filed in another table

is there a specific way..... is there is a globle to to add to Category table in some field to prepopulate the field from another field in another table???

Thank you in advance...
Mark

Hummm no answer from anyone yet...

I found a forum that display what I want.. but does not apply to LinksSQL...
http://www.codingforums.com/showthread.php?t=63636

can anyone please tell me where should I make the modification to pre-populate a field of a table from another table in the same Database....

Like I have categories db and clients db, and when I want to add a new category, I want the all the client names (from another table) show up in a dropdown menu in the categories add form...

Thank you for any help...
Mark

Anyone!
Thank you