If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Only allow recor addition to a table if linked table/field is true
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 -- Three Steps To Happiness : Ctrl-Alt-Del |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Get data from combo box to popluate the next box | Lin Light | Using Forms | 4 | December 30th, 2004 05:01 PM |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
Requery external linked table? | Keith B. | General Discussion | 0 | November 29th, 2004 06:15 PM |
Linked table to mapped network drive | Zattack | Running & Setting Up Queries | 1 | November 10th, 2004 08:10 PM |
Name not showing ID is | René | Setting Up & Running Reports | 11 | June 29th, 2004 01:40 AM |