View Single Post
  #2  
Old November 17th, 2009, 03:17 PM posted to microsoft.public.access.tablesdbdesign
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default one to many or many to one

On Tue, 17 Nov 2009 05:01:01 -0800, MitzDriver
wrote:

I don't know what you mean by "PF".
TblShowings should have an additional field ListingsID. Then in the
Relationships window you can draw the line from TblListings.ID to
TblShowings.ListingsID *and enforce that relationship*.

-Tom.
Microsoft Access MVP


The last time I did anything with a database was with dBaseI. And I know this
is a very simple thing for you all......But

Using access 2007 I have two tables.

TblListings
ID autonumber
owner text
address text
phone text
mlsno text PF

TblShowings
ID autonumber PF
date
time
agent
agent phone.

For every TblListing there will be many showings. How do I set the
relationship between the two? Do I, should I, change the PF on each table? Do
I need to add a field to TblShowings? I would like to use a form frmListings
with a subform frmShowings. So for each Listing, all past and scheduled
showings are there.
Your help would be greatly appriciated.