As all things, this sounds simple but I can't figure it out.
I have a form for client information with these fields:
First Name
Last Name
Phone
Car
several other fields
I have another form that deals with work done on cars and I want it to pull up some of the fields from the client info form (display only)
I have a look up in the work form for last name that looks up the last name from the client info form. I would like for it to pull the telephone number and car off that form and display them in the work form when I pull up the last name AND I want those other fields displayed in their own field, not with comas or whatever in the last name field. I just want them displayed, I don't want to be able to change them.
This is going to be a checklist for me and I will never create a report for it. I am saving the data in case I do not finish in one day. So don't think report here.
Can I get some direction, please? I know this is basic for some of you. Thank you.