Auto-populate form question

[trb5016]

Alright couple things to notice with this.

1.) The booking tables has what's called a Surrogate Key, the autonumber field call BKG_ID. This ensures uniqueness in the records. Really there should probably be other restrictions but we won't worry about those.

2.) The form's recordsource is based on a query (stored in the form) that joins the 2 tables.



3.) New records can be added using the navigation buttons at the bottom.

4.) Before booking a customer, they MUST have a record already in the customer table

Let me know if you have any questions!

[revnice]

Sounds awesome, I can't wait to check it out.

Mighty thanks!

(Do I Import it somehow?)

[trb5016]

You can try and import if you want, I don't mind you using this. It might be a better learning experience if you tried to build it from scratch but *shrug* lol

[revnice]

>if you tried to build it from scratch
Oh I will! But I want to be able to see what you did by clicking around in it as well as having the instructions. I have to go to a different machine for this.

Thanks again, I'll be back

[revnice]

trb5016:

This is amazing! I'm so happy I can start playing with the whole thing now.

1) How do I add fields to the existing form?
I know how to do it when creating the form but not after it's made.

2) If I add fields from the existing tables, will I have to edit the query or will it still function as is?

3) I noticed that the Bookings table won't allow more than one booking by the same cus, how do I change that?
If I try to book the same cus into an additional course, it just changes the existing data.

4) How/where do I go to see the query you made?
That's the part/procedure that baffled me before.

5) How did you get that date picker to appear!? That's so cool, I'd like to put it on all the date fields.

5) How did you export the whole thing as one file with the .accdb extension?
I looked for 'Export Database' in the Help and couldn't find anything. I tried Save As but it wanted to save the current table or something like that.

I'm very impressed and very grateful...

Thanks a million!