General information
Forum:
Microsoft SQL Server
Chun,
Try this query.But i run it with access.you make change as your requirement.
Query:
CREATE TABLE groups_role
( groups_id text NOT NULL, gr_role text NOT NULL, gr_add bit NOT NULL, gr_edit bit NOT NULL, gr_delete bit NOT NULL, gr_read bit NOT NULL, PRIMARY KEY (groups_id, gr_role), FOREIGN KEY (groups_id) REFERENCES groups(gr_id));
you change text as varchar and create groups table separetly.ok.All the best.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only