auto complete

[ben1988]

hi :)

how I can define value, which come from other table, base on field on current table as "default value"

and when user decide change this accepted value - it's not change the origin valve in the source table.

for example:

the user fill the field "shiftcode" in table 1
he gets in the field "starthour" default value from table 2 - which mean when the shift start - spouse 14:00
but today something happened and the shift started from 13:00 so he can change the correct hour in "starthour" field
but in the origin table (table 2) the value still stay 14:00


thanks!!!

[zmbd]

ben1988,
You're not going to be able to do this very easily at the table level.

+ There are table level data-macros in ACC2013 and newer that could potentially be used; however, I wouldn't recommend this approach. Instead, you need to look at implementing this at the form level.

+ From the example you've provided, it doesn't sound like you are actually trying to change the field's default value property, just the data being entered for the record. Without the tables and the relationships it's hard to tell just exactly what it is you are doing. The example also makes it sound as if there is something amiss in how your tables are related. Take a read thru our insights article:
Database Normalization and Table Structures