Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan SQL : Discussion :

User owns specific records

Feb 12, 2002, 6:40 AM
Sir Up
User (479 posts)
Sir Up's avatar
Feb 12, 2002, 6:40 AM
Views: 2527
Shortcut
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

Subject Author Views Date
Thread User owns specific records Sir Up 2527 Feb 12, 2002, 6:40 AM
Post Re: [Michael Skaide] User owns specific records 		Sir Up 2470 Feb 13, 2002, 7:31 AM