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
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
"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'? |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to clear controls of Filter form | Jan Il | Using Forms | 2 | November 28th, 2004 02:04 PM |
Putting code in a subform? | Maury Markowitz | General Discussion | 14 | October 25th, 2004 11:32 AM |
Data not showing on form when reopened | SueM | Using Forms | 3 | August 21st, 2004 11:08 AM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |