NoDuplicates 1

[Elvis72]

OK I have two tables:

TblConstructionServices
TblResumes

Both are no duplicates.

BUT I have another table TblProjectInfo which brings together both tables.

Now here is the tricky part in my head...

If I have Proposal Number: 12345 in the Construction Services Table

And I have WorkerID: 3 in the Resume Table

I need to limit TblProjectInfo to only having one record for WorkerID:3 under Proposal Number: 12345

But I am at a loss as to how to do that?

 

[Remou]

You can have unique keys that include multiple fields.

 

[Elvis72]

OK, I'm not seeing a way to create a unique key that recognizes when 2 fields are the same?

 

[Remou]

In table design view either:

1. Mark the two fields by ctrl-clicking or dragging in the field selector and choose the 'key' from the toolbar; or

2. Chooses the 'lighting flash' (indexes) from the toolbar or View->Indexes from the menubar and add the fields manually to a an idex.

Have you had a chance to read

http://r937.com/relational.html?

 

[Elvis72]

DUH...I have been using Access for years...never actually had a reason til now to do that?

Thanks so much, yes I have read it...and gleened some information from Allen Browne...which has given me a better view of them.

But I am not the type to read and understand...I kind of have to get knee deep in it and figure out there is a better way...lol

If someone would come up with a 3D walkthrough of the databases and how things interconnect sign me up!~