Jump to content

Archived

This topic is now archived and is closed to further replies.

cK

UNIQUE

Recommended Posts

Hi,

 

I know how to make a field in a table UNIQUE, but have no clue if it\'s possible to make 1 field on two (!) tables UNIQUE and how to do this!

 

For example make sure the are no duplicates in the \"login\" data (= username) so never ever a client will login and get - by accident - the stuff of the supllier with the same login. Putting everything in one table would be a solution, however my current cms-system can\'t handle this.

 

client_id | username | password | more clients stuff...

supplier_id |username | password | more supllier stuff...

Share this post


Link to post
Share on other sites

The only way to do that would be to search for match in the other table.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.