Only allow recor addition to a table if linked table/field is true

C

ChrisBarnes

I am currently designing a database to record group trips within our
organisation.

I have normalised the data down as far as I can and now want to start
thinking about the general flow of information and rules for it.

I want to make sure that only eligable groups can have a record added to my
trips table, I have set up a relationship from the groups table (which has a
logical field called Eligable) to the Tbl_Leaders table, which in turn is
linked to the trips table via LeaderID (Primary key 1 to Many relationship)

How can I set up validation rules/VB to make sure that only group types
which have the eligable flag marked as true can have a record added to the
trips table?

Also, is there any way that I can have the TripID field inserted
automatically as I drill down through the tables or should I rip it up and go
un normalised?

TIA
C
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Format column widths from one table to a separate table on same page 1
Crating User Form to Add Names 1
VBA - (re-) Set a Table Style 2
Auto-Numbering in a Table in MS Word 1
Adding Heading to Table of Contents after a column break 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Making a macro only work on certain files 2

Top