Gossamer Forum
Home : Products : DBMan SQL : Discussion :

User owns specific records

Quote Reply
User owns specific records
I have a table with invoices. There is a column with an affiliate number in this table.

Now I want to use the user table to store there the affiliates as users. I added an extra column to the user-table where I want to store the affiliate number.

What do I need to do that the affiliate-number in the user-table refer to the affiliate number in the invoices table, so that itīs like this user would own these records.

Michael

--
Michael Skaide

http://www.cycle24.de

Quote Reply
Re: [Michael Skaide] User owns specific records In reply to
I think I found it out

--
Michael Skaide

http://www.cycle24.de