How do i verify data using another form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When i enter data in to table A, I want access to search field 1 in table B
and only accept the data i am entering if it is present in field 1.

Any help doing this would be much appreciated coz i have already pulled half
my hair out trying to do it.
 
When i enter data in to table A, I want access to search field 1 in table B
and only accept the data i am entering if it is present in field 1.

Any help doing this would be much appreciated coz i have already pulled half
my hair out trying to do it.
Click to expand...

Open the Relationships window (the icon looks like three datasheets
with lines between them). Join TableA to TableB by field1 (which needs
to be the Primary Key in whichever table has Field1 as the unique
value, probably TableB). Check the "Enforce Relational Integrity"
checkbox.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
John Vinson said:
Open the Relationships window (the icon looks like three datasheets
with lines between them). Join TableA to TableB by field1 (which needs
to be the Primary Key in whichever table has Field1 as the unique
value, probably TableB). Check the "Enforce Relational Integrity"
checkbox.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...


Is there not a way to do it using a validaion code? I thought you can do it
using 'getdata'?
 
Is there not a way to do it using a validaion code? I thought you can do it
using 'getdata'?
Click to expand...

Well... you probably could, with considerable difficulty. I'm not
familiar with "getdata" - is that an Access function, or SQL/Server,
or some other programming environment?

Field validation values cannot reference other tables, other fields,
or user defined functions; and they're pretty user-hostile as well.
Could you explain why you're reluctant to use the native, built-in
referential integrity constraints which are the standard way to do
this?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top