Unique Situation - Table needs to read primary id instead of name

[sandingdude]

I am actually recreating a friends database for his non profit organization. He then is going to export this database into a csv file so he can then upload it to a php based website. This website will pull the data from the database and display it on the webpage. Its actually a membership database.

This is my problem. I have built some relationships in this table. And I am using the lookup feature so I can select the appropriate company with the appropriate representative.

If I change the lookup to the company id (which is a number), I have no idea what that company is until I go back and look at it. The problem is the php script cannot work with the name of the company, rather it needs the id to relate to the other tables. I tried changing the lookup back to company id, after selecting several of the names as a test, and the names stayed and did not change back to the ids.

Please help. Thank you in advance.

 

[BNPMike]

Relationships don't affect the situation. If you transfer your tables into MySQL (I'm guessing - that's the common partner for PHP) then you can use the same SQL technique that you are using in Access. You can't use entirely the same SQL as MySQL is slightly different and won't accept the complex statements that Jet will.

If you are not using MySQL (or any database) then do so. Or you could try SQLite - php5 has that included as well.