reading values from another table to create a default value automatically 
Author Message
 reading values from another table to create a default value automatically

i would like assistance displaying field values from another table as
the default value of a certain field.

i have a standard crop time table with a composite primary key of
variety id and container id, each variety and container have a specific
crop time.  There is a detail table that has weekly detail records, a
field in that table is crop time and the default crop time needs to be
displayed from the master crop time table, BUT in the detail table, the
crop time values need to be available for edit, so in the detail, when
they are entering, a standard value pops up, cooresponding to the
variety and container and filled in automatically for them to retain in
the detail record OR change if necessary

thank you very much in advance...i do not think i want a lookup...they
are not choosing the value, rather, i want it filled in automatically



Fri, 05 Jan 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Creating a default field value in a form based on the highest value in a table

2. setting default value in form based on diffent table value

3. setting default value in form based on diffent table value

4. Set Default Value of Text Box in Form to be Max Value of Table Field + 1

5. Table value as a default value in a text box control

6. setting default value in form based on diffent table value

7. Setting a value in one table to the default value in another

8. set default value of field to value in a field in another table

9. using a function return value in a default value section of a table

10. Find certain values and create new table with replaced values


 
Powered by phpBB® Forum Software © phpBB Group