Binding a form to more than one table

[Simon Harris]

Hi All,

I am currently designing an Access DB for storing details of who is staying
in what pitch on a number of Holidays parks. So far, I have the following
table structure:
tblCustomers----tblAllocations----tblPitches----tblParks

I want to have a form that allows adding/update of customers, including what
site and pitch they are on, which I want to store in the allocations table.

Can anyone advise how best to achieve this? Should I design a query that
does the join, then make this the source of the form? Or perhaps manually
run SQL commands to to the various updates following the save/update button
being clicked?

Thanks,
Simon.

 

[Duane Hookom]

This all depends on how you get your information. I would probably create a
main form that is bound to tblCustomers since that might be one of the first
pieces of information you need to create a reservation. Then, add a subform
for reservations that would be bound to tblAllocations. The subform could
use a combo box bound to tblPitches.

Consider reviewing the Northwind orders form.

 

[Arvin Meyer [MVP]]

You can build a query to link multiple tables as a form's recordsource. You
can also use subforms to display related data from several tables. I'd use
the subform approach in your circumstances.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[PCD]

Simon,

I have a reservations module that displays reservations in a grid. Dates are
on one axis and sites are on the other axis. The grid shows each site
reservation; blank areas in the grid indicate no reservation for the site on
that date. Clicking on any site reservation pops up a form showing the
details of the reservation.

I also have a scheduling calendar module. The module includes a calendar
form and a calendar report. Different (multiple) reservations can be shown
in each day of the calendar in both the form and report. You could show the
site and the name of the reservation in each day of the calendar. The
calendar form can be programmed to pop-up a form for entering and displaying
reservations for any calendar day you click on. One of my customers uses the
scheduling calendar module to schedule training classes in a conglomerate of
eight hospitals and another customer uses the calendar to display sales
calls for his outside sales staff.

I can implement either of these modules for you in your database for a
reasonable fee. If you are interested, contact me at my email address below.

 

[StopThisAdvertising]

"PCD" <[email protected]> schreef in bericht
--

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1150 users have come to me from the newsgroups requesting help '1150 users ????
(e-mail address removed)

--
To Steve:
Why don't you get lost with your advertising/jobhunting here.
Over 575!! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R

 

[PCD]

All you are doing is INDEED showing every newsgroup reader that you are
nothing but an OBSESSED, egocentric A$$. You revel in tracking every post I
make in the newsgroups and do not make any contributions to our newsgroup.
Take the advise that was given to you by a poster not too long
ago and grow up and get a life. We don't need the likes of you in our
newsgroup! Just get lost and quit filling our newsgroup with your slanderous
garbage!!!!!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1150 users have come to me from the newsgroups requesting help
(e-mail address removed)


"PCD" <[email protected]> schreef in bericht

--

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
'Resource ????
Over 1150 users have come to me from the newsgroups requesting help
'1150 users ????
(e-mail address removed)

--
To Steve:
Why don't you get lost with your advertising/jobhunting here.
Over 575!! users from the newsgroups have visited the website to read what
kind of a 'resource' you are... (rapidly increasing..)

To the original poster:

Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell
his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R