Linked tables and Relationships

[cathalfarrell]

Each employee has their own database containing a table of log in and out times.

The main database links to that table in each of the employess databases, a UNION query compiles all these tables.

Is it possible to have a create relationships with linked tables?

 

[namliam]

Linked tables work exactly the same as normal tables... so yes...

 

[cathalfarrell]

APPEND Query

Thanks for this Namliam

If I use an APPEND query to create one table instead of many linked tables, can I also create a relationship?

 

[namliam]

You mean, you have like 10 tables...

Then append all these tables into one table...

Then why would you want to create a relationship?? Tho you can "self join" a table, but why???

 

[cathalfarrell]

Yea I have a linked table for every employee, which isn't good!

The DailyLog Table fields are
Trainer
TodaysDate
StartTime
FinishTime

I would like to create a relationship with Employee Table
EmployeeID (KeyField)
TrainerName
Client

and from Employee Table to Clients
ClientID (Key Field)
Client Name

I can create the relationship between Clients Table and Employee Table, which works fine.

But when I create a relationship between Employee Table and Daily Log Table it doesn’t seem to relate the details.


But I have included a screen dump and my database

 

[neileg]

Unfortanately I can't attach my database, too big even when compressed, which surprises me beacuse there isn't a lot of information contained within.

Have you done a repair and compact?

 

[cathalfarrell]

Thank Neileg

I've been able to attach to my previous message now.

 

[cathalfarrell]

Probably Best

thanks for this Pat,

I was thinking that this was the case, I was hoping there was an easier way than restructuring my whole database.

Probably best in the long run though.

Thanks again