A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old January 26th, 2005, 04:41 PM
ChrisBarnes
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 06:01 PM
Prevent Blank Records being written. Need Help. Robert Nusz @ DPS Using Forms 4 December 29th, 2004 06:15 PM
Requery external linked table? Keith B. General Discussion 0 November 29th, 2004 07:15 PM
Linked table to mapped network drive Zattack Running & Setting Up Queries 1 November 10th, 2004 09:10 PM
Name not showing ID is René Setting Up & Running Reports 11 June 29th, 2004 01:40 AM


All times are GMT +1. The time now is 12:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.