How do i verify data using another form?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Calum112 - 28 Nov 2004 21:29 GMT

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.

Reply to this Message

John Vinson - 29 Nov 2004 01:44 GMT

>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

Reply to this Message

Calum112 - 29 Nov 2004 11:41 GMT

> >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.
[quoted text clipped - 12 lines]
> 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'?

Reply to this Message

John Vinson - 29 Nov 2004 21:19 GMT

>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

Reply to this Message