I am doing a facilities reservation database. Situation as below:
Every member has a membership which is authorized some facilities. Therefore, if a member reserve a facilities which is not authorized to his membership, it need to be charged and store into the reservation record table as an attribute reservation_fees.
How can i do the constraint? or check?
kevin7807
0
Newbie Poster
LastMitch
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.