Table Linking and Queries??

Afternoon All,

I have created a table for states of a country. To me this table is like a
store for information. I wont be updated by user interaction.
StateID StateName StateTelephone Code
1 Cundinamarca 1
2 Cordoba 914

I have one table for clients and in this table I have StateID, I also have
one table for Offices which I have added StateID as well.

In my relationships table how do I link them. Do I add one States table and
then link to both the clients and offices table with referential integrity?
Or do I just ignore referential integrity?

Which leads onto the next question I have a query that brings all the tables
to create my report. How do I have to link them in the query? Or should it
be automatic because of the relationships I have already setup?

In my report I want to show the telephone codes which relate to the state
for the office and the client which could be different. But I keep getting
errors on the report.

I thought this was the best way of doing this as I wouldnt duplicate the
data for the phone code in multiple tables, but in the end I cant make it
work.

What am I doing wrong?
Scott V


.

Relevant Pages

  • Re: Summarizing records in one table that match a different table
    ... the report. ... using "Language" as the example (i had to add a field to my Clients test ... i created a report based on the query with the joins ...
    (microsoft.public.access.reports)
  • Re: report showing all
    ... If a report returns blank, then go to the query behind the report. ... named Restaurants, and that form is open when the query runs, then... ... That worked wonderfully for my Clients. ...
    (microsoft.public.access.reports)
  • Re: Blank Subreport for table with no related records
    ... I had to adjust a little because my main report is based on a query to ... As an example, say the main report lists clients, and the subreport lists ...
    (microsoft.public.access.reports)
  • Re: Formatting/Coding a Report...
    ... Then you could export the query a an Excel ... or you could set up a report with that same ... > whether they are new or existing clients. ... > totals column on the right side of the report for individual programs and ...
    (microsoft.public.access.reports)
  • Re: Summarizing records in one table that match a different table
    ... > the report. ... > using "Language" as the example (i had to add a field to my Clients test ... i created a report based on the query with the joins ...
    (microsoft.public.access.reports)