Auto Populating a new form

[mikejames]

Hello, I am entering data into the "New Client Information" form (which is stored in the Client Information table). Once a user completes this form I would like to click on a button, open the "Scheduling" form (which store data in the Scheduling Table) to begin scheduling this client's appointment with fields auto populated from the "New Client Information" form.


Thank you.

[RuralGuy]

Maybe this is what you want to use: http://www.baldyweb.com/Bookmark.htm

[mikejames]

Thanks RuralGuy, Its close. What I am looking for opens a new form (with auto-populated fields) saving to a new table.
I greatly appreciate your help- I will use your suggestion for something else I am working on.
MikeJames

[RuralGuy]

Didn't you join the Scheduling Table with the Client Information table on the ClientID field and use it as the RecordSource of the Scheduling Form?

[mikejames]

I joined them as Queries. Is that what I should do? Join those fields as Tables?

[RuralGuy]

Joining as queries is fine. Can you see *all* the fields of both tables and can you update them in the query?

[mikejames]

Yes I can see all the fields of both tables. In my attempt, I was joining Client Last Name. When I returned the the forms to test the work a new record didn't open with the field populated.

[RuralGuy]

Do you have ClientID in both tables?

[mikejames]

I have the field "LastName" from the Client Information Table/Query joined to the field "Last_Name" to the Scheduling Table/Query.

[RuralGuy]

What happens when you get another Client with the same last name?

[mikejames]

I have the first name fields joined together as well. Should I create a ClientID field with a number?

[RuralGuy]

I have the first name fields joined together as well. Should I create a ClientID field with a number?

That would be the best approach. Then you could have more than one Client with the same first and last name. It should be an Autonumber field and the ForeignKey field in the other table would be a LongInteger field. Be sure and remove the indexes from the name fields to speed up the system.

[mikejames]

I will work that out and let you know the outcome. Thank you very much for taking the time to answer my questions and providing your expertise.