How do i verify data using another form?

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.

On Sun, 28 Nov 2004 13:29:04 -0800, "Calum112"
wrote:

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.

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" wrote:

On Sun, 28 Nov 2004 13:29:04 -0800, "Calum112"
wrote:

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.

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



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

On Mon, 29 Nov 2004 03:41:09 -0800, "Calum112"
wrote:


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

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