Help For a Newb to Construct a Table / Query

[Andibevan]

Hi All,

I am a bit stuck on something that I am sure is relatively simple.

I have a data table that contains ArchiveID and ArchiveLocation in it
(also lots of other info not needed for this example)

I want to create another table that contains ArchiveID, ArchiveLocation
and another field WorkfileLocation.

WorkfileLocation by using the ArchiveLocation in a user defined
function.

I am stuck as I can't workout whether I need to create a table or a
query?

TIA

Vlad

 

[Jeff Boyce]

Vlad

Since Access is a relational database, you wouldn't need to include both
ArchiveID AND ArchiveLocation in the second table. You could simply use
ArchiveID to "point back" to the record in your "Archive" table that holds
Location.

It is a little difficult to offer suggestions for table structure without
some idea of the relationships involved. Does each ArchiveID have just one
WorkfileLocation, or many?

 

[Andibevan]

Thanks - Each ArchiveID will have only one workfile location.

 

[Jeff Boyce]

I don't see the rationale for a second table, if each ArchiveID has one
ArchiveLocation and one WorkFileLocation.

Perhaps there's more to your situation than you've describe...?