Many to Many Relationships
anonymous_at_discussions.microsoft.com
Date: 07/09/04
- Next message: sheela: "move the deleted records to another table"
- Previous message: Vadimbar: "Re: Query Sums by date and client restriction"
- In reply to: Lynn: "Many to Many Relationships"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 9 Jul 2004 07:08:09 -0700
I have done many databases with many forms and here is a
trick I use to creat forms, etc that I use all the time.
Now mind you, there are some that say this is not the way
to do it, but I have used it for years and have had no
problem. Maybe luck? Don't know, but it works for me.
I create all my tables, and create the links. Then for
the form, I create a query from the created/linked
tables, that contains all the fields from all the
tables. (now if you have extremely large tables, this
probably may not work). The result of the query will be
all the information from all the tables. Then I create
the form with the wizard using this query as my source
and just pick the fields I want. Since I have one query
with all the proper linking, etc., I also use that query
as the source for lots of other queries. Saves me time.
But again, there are some that say you should not do
this. I have never seen the downside of it. If anyone
knows what it is, please let me know. Hope this helps.
>-----Original Message-----
>Good morning. I am new to Access databases and to date
I
>have done a considerable amount of research and reading
>but am unable to ensure the steps I am taking in the set
>up of the tables will work as I design the forms and
>reports. I have set up tables for Customers that will
>link to Quotes and Jobs. Quotes and Jobs both have sub
>tables linking to details that will be used for line
>items.
>
>To this point I have inserted two tables for
>Customer/Quotes and another for Customer/Jobs which if I
>understand correctly will link the Customers with Jobs
>and Quotes. I can have many Customers that may have
many
>quotes or many jobs.
>
>I understand how the set up of the tables is vital for
>the database to work correctly.
>
>This is the first step and once I know I have done this
>correctly I need to understand how I use the tables
>created to set up my forms.
>
>Thank you in advance for any assistance you can provide
>to help me to go on from this point.
>.
>
- Next message: sheela: "move the deleted records to another table"
- Previous message: Vadimbar: "Re: Query Sums by date and client restriction"
- In reply to: Lynn: "Many to Many Relationships"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
