transferring data to new table in Access 2000

[Carmion]

I am trying to create a new table/report using data from
Guest Tracker. This database already exists in Access
2000, I have created the table in the database and
created the relationships necessary to share the
information. The data that is in the related tables is
not coming through to the new table. This is probably a
very simple step that I am missing but after a lot of
time trying to figure this out I still can't. Can someone
help?

 

[GVaught]

Would you explain your statement: I have created the table in the database
and created the relationships necessary to share the information. How are
you expecting the data in the related tables to show up in the new table?

If you have data in a table that is in another database you can link that
table into your new database and then use that data as needed. You would not
need to create a new table. Just use the File | Get External Data | Link.
Linking the table allows you to update the table from your own database.
Don't use import; this just copies the table into your database and would
not update the Guest Tracker tables in the Guest Tracker database if you
made changes within your database.

 

[Larry Daugherty]

Hi Carmon,

I think you miss-understand what a relationship is and what creating one
does. Relationships and "sharing" data exist in different dimensions or
universes.

I'd create a copy of your existing database and move it into a Sandbox or
Practice area so that fadiddling won't destroy real data.

If the result you want is a Report based on data that already exists in your
database then start by creating a report based on that table. First get rid
of the new relationships you've created and get rid of the new table you've
created (unless it has new data that doesn't already exist in your database.
If you're not used to creating reports then select the table in the
database|tables window and click the Autoreport Wizard. Step through that
process a few times to see what kinds of reports Access will generate for
you. Settle on one report that comes closest to what you want to do,
including the sort orders, etc.

You can further modify the design of the report to suit your taste and
requirements by changing the visible layout and componentry and by getting
into the data side and altering the underlying query.

I think the above addresses what you really want to do. If not, please
accept my apologies and post back with a statement of what you are trying to
achieve and what you've already tried along those lines.

HTH