Pop up form

[Dega]

Hi,



I have a form (customer) with a sub form (bookings-table) with a one-to- many relationship from customers to bookings with the CustID being primary key.

This works for a single party booking but I need to sometimes add a second, third or fourth (max) person to this booking and include them in this particular tour. (tour and hotel accomodations). The information gathered will be the same as the single party who first booked ... but will be adding family or friends to the tour.

What I was thinking of was a pop-up form which would permit me add persons to the original single party booking which is almost always the case, as very few persons tour as a single person.

Can anyone suggest how I can do the above?

I am somewhat versed in sql and a few other things ... but green with access 2007.

Thanks,

Dega

[jbarrum]

Use the tool bar to creat a button. The button wizzard will walk you thru options such as opening a form or running a report. You can choose to open a form. If you want the form to popup when opened then you will need to open the form in desgin view, go to it's properties and on the "other" tab the first line for "popup" needs to be set to "yes"

[RuralGuy]

Dega,
It looks to me like you have a m:m relationship rather than a 1:m one.

[Dega]

Thanks for the replies ...

What I did is tried all kinds of combination and dragged several tables into my main form (4 sub forms). I have the relationships on a word file but I don't think you allow uploads?

The data and relationships look like they work but I can't imagine anyone wanting to work with this mess I created other than myself, and sooner than later someone else is going to have to work with it.

First I thought of pop-up windows and thanks for that explanation but I now think working with tabs would seem to be a lot more organized.
Forms/tables: Customers, Guests, Bookings, Rooms and later Payments.

Uncertain how tabs behave and any behavioural quirks that may come up using them?

Thanks

[jbarrum]

tabs would work jsut as well, and yes the sight allows uploads so if you need to share a screen print, word document of sample db you can

[RuralGuy]

Here's a link to directions on how to attach stuff to a post.
https://www.accessforums.net/forum-s...ages-1848.html