Hello guys,
I've just purchased phprunner and I think it was sent from heaven. I am not a well advanced programmer simply because I do not have time over manageing my business and assigning projects to my employees. But I learn fast <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=12495&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
I am creating a custom app and i have tables setup in this layout...
my users table just holds(userid,email,pass,active)
then userid is key and foreign key in company_info table which holds all company info, contacts, web site etc(companyid,userid,companyname,etc,etc,etc)
All other tables are one-to-many foreign key "companyid"
Now users login and see only their own data...
But staff is adding all data so my question is...
If I create a table just for company id and company name lets say(id,companyid,companyname)
How could i create a way to set/change a session that hold companyid that can be changed with drop down so when staff logs in they can set company name which holds companyid as value, then at all add pages to all other tables auto fill the companyid ?
Thanks in advance...
RD