I am new to Access, so bear with me.

I am using Access 2007.

I have 4 tables created, and they are breaking out information for recording files that are being created from a PBX.
The tables are created as thus:

tbl_1
Key:ext_id | extension

tbl_2
Key:loc_id | location

tbl_3
Key:f-type_id | filetype


tbl_4
Key: mass_id | filename | date | loc_id | ext_id | f-type_id


Now I have created the relationships between the tables for the various ID's. My issue is the following:

I will be automating this process, so when the data is imported to the various tables, I need the relevant keys from tbl_1 tbl_2 and tbl_3 to be added to tbl_4 when the new data is brought into the tables.

As to the process of importing the data, I was looking at using PHP to facilitate this. Any ideas, help or direction would be greatly appreciated. I have looked around the net for an idea of how to solve this, but, being so new, I am not exactly sure how to word the question.


Thanks!

Could you post a sample of the data you will be importing?

basically the data that i will import will be derived from the filename of the wav file..

Ex: user-8010--out-1188578897-44-Fri_Aug_31_2007_12_48_17_PM_EDT.wav


from this filename, I am going to parse out the following information:

user extension: 8010
End Date info: grabbed from the last modified timestamp
FIletype: wav
Storage directory location: \\computer\directory


eventually I will be including a script that will convert the files as they come in to a mp3 format.

I hope this helps.