Member Avatar for fireprooffox

hi,

i hv a residential facility reservation database in which the facility can wither be a hotel or a guest house. Now, i hv created these tables(along with many other)

#############
Facility Table
Facility ID
Facility Type
Name
Number of rooms
Address
City
Phone

##############
Table Hotels
Facility ID
Tieup ID
Number of Stars
guests_per_room

################
Guest House Table
facility ID
purpose
rating


what i want is that the facility id in guest house and hotel should be disjoint(both of them are inherited from facility table). Is there any way in MS access to do it??

  • 2 Contributors
  • 1 Reply
  • 47 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by MidiMagic
Member Avatar for MidiMagic

Make Faculty ID the primary key in the Faculty table.

Form one-to-many associations between Faculty table and the other two tables.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.