brosenberg

:thankyou: Wow, I never would have thought of "stacking" fields on top of each other. Thank you once again. I will definitely keep that one in mind.

Hello again, Sorry to do this but for some reason I can't get this thing working. I took a look at the client test files, especially client test 2. I think I understand most of what's going on in it, however I can not get it working in my database. I've looked through it and emulated everything I could see, but even when I started fresh on a new file I still could not get it to do what Client Test 2 does. So far, I've got my Client Info layout/table with the one number field that's for the clientID and the rest of the fields are just plain text fields. I have my job ticket field that contains the fk_clientID (which is related back to Client Info::ClientID) as well as the fields from the Client Info Layout. I have the value list for clientID set to show data from both the clientID as well as client name. I set up the Client Name field in my job ticket layout as a button to do Go to Field with the box for Select/perform checked as well as the box for Go to field checked. The syntax seems to match what you have in Client Test 2. The problem I'm running into at the moment is that when I click on the Client Name field in my Job ticket layout, it doesn't do anything. I can't enter text and I get no dropdown of names/id numbers. I'm sure I'm missing something simple, but I can't figure out what it is. I've attached my fresh-from-the-start file I tried making to emulate the client test 2 file. my_test.zip

Hi thanks for the suggestion, I'm not sure I fully understand what you're telling me though. If I switched to using a ClientID would I then be using the ID number in the Orders table to make it auto-pop the rest of the client info? That probably wouldn't work for the people using the database. Maybe I explained it wrong? Regardless if it's a client ID or name, how do I actually get the information to auto-populate in other fields based on what is chosen in a value list? Also, for some reason I can't seem to get to the attachment, would it be possible to send it to me directly?

Hello, I hope I can explain this correctly. I have two tables, one with client information (name/number/etc) the other is a job ticket table. What I'd like to do is have the user pick a clients name from a value list in the job ticket table (that's related to the client name field in the client info table) and have the rest of the clients information auto populate in their different fields. Currently I have the relationship set up correctly between the client name lists on each table, but I don't know where to start to be able to pick a client name and have it auto fill the remaining fields on the job ticket table. Would this be something I would have to script?