Hi Im having a few problems with my table relationships
I have a number of forms which are used for a Jobs database
The customer goes on line to post a job the job is the automatically emailed to all the relevant trades i.e. a plumber, the first 3 that reply get entered in to my jobs table quote 1, quote2 ,quote 3 this is done manually at the moment. I then have another table which has a list of all my trades people they have to log in via the web site but i need them only to see the jobs they have quoted for, i can do this if i only needed 1 quote by RLS so the user would see their own information but i cant work out how to have a user logging in via an authentication table then only to see the records that have their email in the quote field
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
flashcz
Hi Im having a few problems with my table relationships
I have a number of forms which are used for a Jobs database
The customer goes on line to post a job the job is the automatically emailed to all the relevant trades i.e. a plumber, the first 3 that reply get entered in to my jobs table quote 1, quote2 ,quote 3 this is done manually at the moment. I then have another table which has a list of all my trades people they have to log in via the web site but i need them only to see the jobs they have quoted for, i can do this if i only needed 1 quote by RLS so the user would see their own information but i cant work out how to have a user logging in via an authentication table then only to see the records that have their email in the quote field
Thanks
Derek
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.