Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Using selection to populate data in form

What I am wanting to do seems very simple but due to my lack of experience I must be missing some basic understanding, please help.

Table 1 So I have a job list table: job number (primary key) site name client name

Table 2 I then have a fees list table: fee ID job number site number client name department service fee

So I want to create a form, so when a new fee instruction is confirmed the user can insert or select the job number, which will then pull data from table 1 (site name and client name), and insert all three bits of information into the form, which the user can then add the information for the department, service and fee sections, and it all gets saved to table 2.

I have been trying to do this without a sub form. I have been using a list box which allows selection of only job numbers in table 1, however once that is selected, I obviously want the corresponding site and client names based on that job number to be inserted. This is to remove human error from the user being able to put wrong site and client names to job numbers.

For example is it possible to filter listbox 2 and 3 based on the selection in list box 1??

Thanks in advance Oliver

Using selection to populate data in form

What I am wanting to do seems very simple but due to my lack of experience I must be missing some basic understanding, please help.

Table 1 So I have a job list table: job number (primary key) site name client namekey), site name, client name.

Table 2 I then have a fees list table: fee ID job number site number client name department service feeID (primary key) job number, site number, client name, department, service, fee.

So I want to create a form, so when a new fee instruction is confirmed the user can insert or select the job number, which will then pull data from table 1 (site name and client name), and insert all three bits of information into the form, which the user can then add the information for the department, service and fee sections, and it all gets saved to table 2.

I have been trying to do this without a sub form. I have been using a list box which allows selection of only job numbers in table 1, however once that is selected, I obviously want the corresponding site and client names based on that job number to be inserted. This is to remove human error from the user being able to put wrong site and client names to job numbers.

For example is it possible to filter listbox 2 and 3 based on the selection in list box 1??

Thanks in advance Oliver

Using selection to populate data in form

What I am wanting to do seems very simple but due to my lack of experience I must be missing some basic understanding, please help.

Table 1 So I have a job list table: job number (primary key), site name, client name.

Table 2 I then have a fees list table: fee ID (primary key) job number, site number, client name, department, service, fee.

So I want to create a form, so when a new fee instruction is confirmed the user can insert or select the job number, number in the form, which will then pull data from table 1 (site name and client name), and insert all three bits of information into the form, which the user can then add the information for the department, service and fee sections, and it all gets saved to table 2.

I have been trying to do this without a sub form. I have been using a list box which allows selection of only job numbers in table 1, however once that is selected, I obviously want the corresponding site and client names based on that job number to be inserted. This is to remove human error from the user being able to put wrong site and client names to job numbers.

For example is it possible to filter listbox 2 and 3 based on the selection in list box 1??

Thanks in advance Oliver

Using selection to populate data in form

What I am wanting to do seems very simple but due to my lack of experience I must be missing some basic understanding, please help.

Table 1 So I have a job list table: job number (primary key), site name, client name.

Table 2 I then have a fees list table: fee ID (primary key) job number, site number, client name, department, service, fee.

So I want to create a form, so when a new fee instruction is confirmed the user can insert or select the job number in the form, which will then pull data from table 1 (site name and client name), and insert all three bits of information into the form, form (job number, site name and client name), which the user can then add the information for the department, service and fee sections, and it all gets saved to table 2.

I have been trying to do this without a sub form. I have been using a list box which allows selection of only job numbers in table 1, however once that is selected, I obviously want the corresponding site and client names based on that job number to be inserted. This is to remove human error from the user being able to put wrong site and client names to job numbers.

For example is it possible to filter listbox 2 and 3 based on the selection in list box 1??

Thanks in advance Oliver