fake field in table

[Amanda]

I have a third party event software that I want to use a linked table from my
database for its data, so I don't have to re-enter contact information.

The event software has a table that has name and contact information for
attendees. Let's call it Event.Contacts

My database has a Household table with Name and contact info- call it
Household.contacts. I don't want to create all the extra fields in my
Household table to match the event table. I want to create a fake-table like
Events.Contacts with an extra ID value that ties it to the household table,
and link it back to the Events database.

The fake table would have Name and Contact fields, but would actually be
getting those fields from the Household.Contacts Table, and would have
additional fields unique to the event.

Basically I need to make two tables with a relationship appear as if they
were one table- and then link to it from another database. Is that possible?

 

[Jeff Boyce]

Amanda

You are describing a "table", but couldn't you use a query to return the
combination you're after? Why create a table at all?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Amanda]

A query would be ideal, I could create a query and link it to the event
software database- but the event software has to think its a table in order
to implement it in its front-end. I don't have a lot of control over the
front-end.