triggers in database
how can I create a relationship between two tables where if a table uses another table as a primary key the other table just automatically fills in space for the other table.
let me go clear now
I have a community table and a user table. what I want is that if the community adds a user as a foreign key the user table should automatically fill in the community_id column since I have made a foriegn key to the user
let me go clear now
I have a community table and a user table. what I want is that if the community adds a user as a foreign key the user table should automatically fill in the community_id column since I have made a foriegn key to the user
