Ask Your Question

oli@sf's profile - activity

2018-01-31 21:12:39 +0200 received badge  Famous Question (source)
2017-12-04 18:58:24 +0200 commented answer Using selection to populate data in form

ok, and thanks for all your help :-)

2017-12-04 17:57:34 +0200 commented answer Using selection to populate data in form

ok sorry I appreciate that, but cant seem to add a copy of my DB in comments for you to look at. Failing that where woul

2017-12-04 16:12:42 +0200 commented answer Using selection to populate data in form

So if for instance I enter a fee amount of £250 then press enter instead of selecting the next box via 'tab' or the mous

2017-12-04 16:12:16 +0200 commented answer Using selection to populate data in form

So if for instance I enter a fee amount of £250 then press enter instead of selecting the next box via 'tab' or the mous

2017-12-04 15:42:58 +0200 commented answer Using selection to populate data in form

Thanks, where in the form settings should I be looking to change this?

2017-12-04 14:19:53 +0200 commented answer Using selection to populate data in form

Ok its all working great now thanks. But Im using form fields instead of a table for the subsubform to enter the data i

2017-12-04 14:19:39 +0200 commented answer Using selection to populate data in form

Ok its all working great now thanks. But Im using form fields instead of a table for the subsubform to enter the data i

2017-12-04 14:13:01 +0200 marked best answer 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 (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

2017-12-04 14:13:01 +0200 received badge  Scholar (source)
2017-12-01 18:03:12 +0200 commented answer Using selection to populate data in form

Its ok I sorted it I must have inadvertently scrolled the mouse wheel after selecting 'refresh form' action for the push

2017-12-01 17:57:46 +0200 commented answer Using selection to populate data in form

Ok so I have the jobs number selection dropdown and client and site name text boxes set up as in yours, but the text box

2017-12-01 16:05:51 +0200 received badge  Notable Question (source)
2017-12-01 15:56:11 +0200 commented answer Using selection to populate data in form

That looks really good so far, the use of the filter table seems to solve it. I'm yet to apply to my database but thank

2017-12-01 13:01:33 +0200 commented answer Using selection to populate data in form

Thanks so much for this, I will check it out shortly.

2017-12-01 08:33:55 +0200 received badge  Notable Question (source)
2017-11-30 19:50:02 +0200 received badge  Popular Question (source)
2017-11-30 18:55:41 +0200 received badge  Popular Question (source)
2017-11-30 17:19:53 +0200 commented answer Using selection to populate data in form

thanks so much, I am getting quite frustrated with this because I know it must be simple and so I am missing something b

2017-11-30 17:14:04 +0200 commented answer Using selection to populate data in form

Sorry but I may be missing a basic understanding here. To compliment the SQL method in your answer above, do you know of

2017-11-30 17:11:17 +0200 commented answer Using selection to populate data in form

So two separate entries might look like this... 1. SF2506 (job number), Meanwood Castle (site name), John Smith (client

2017-11-30 17:08:46 +0200 commented answer Using selection to populate data in form

Sorry, excuse my potential newbie misunderstandings. I don't actually know whether this can be done without duplicating

2017-11-30 17:08:46 +0200 received badge  Commentator
2017-11-30 16:59:16 +0200 commented question Surely this should be easy to do

sorry I will remove it

2017-11-30 16:56:43 +0200 commented answer Using selection to populate data in form

so I though if they could select the job number (primary key table 1), then site name and client name (colmns 2 and 3 fr

2017-11-30 16:54:55 +0200 commented answer Using selection to populate data in form

They also when filling out the form, if say they put just the 'job number' in, need to be able to confirm the site name

2017-11-30 16:54:35 +0200 commented answer Using selection to populate data in form

They also when filling out the form, if say they put just the 'job number' in, need to be able to confirm that the site

2017-11-30 16:52:12 +0200 commented answer Using selection to populate data in form

But each job number and corresponding 'client name' and 'site name' need to be used multiple times (for each new item so

2017-11-30 16:50:49 +0200 commented answer Using selection to populate data in form

The basic problem is I dont want users who are recording sales data to insert 'job numbers', 'site names' and 'client na

2017-11-30 16:48:46 +0200 commented answer Using selection to populate data in form

Hi Thanks, so Table 1 is just for the purpose of providing information in a listbox in a form. So that users can only se

2017-11-30 15:57:02 +0200 asked a question Surely this should be easy to do

Surely this should be easy to do I have a table (Table 1) with a list of job numbers (primary key) in column 1, and corr

2017-11-30 13:02:54 +0200 commented answer Using selection to populate data in form

Then the next two boxes/fields were autofilled with the corresponding 'site name' and 'client name', or were listboxes w

2017-11-30 13:01:28 +0200 commented answer Using selection to populate data in form

Ok, from looking at the links you sent me: So I am really trying to use Table 1 (list of jobs with 'job num', 'site nam

2017-11-30 12:08:46 +0200 commented answer Using selection to populate data in form

Great thanks for the response I will take a look at the links you provided today. Cheers

2017-11-28 18:16:10 +0200 edited question Using selection to populate data in form

Using selection to populate data in form What I am wanting to do seems very simple but due to my lack of experience I mu

2017-11-28 18:15:36 +0200 edited question Using selection to populate data in form

Using selection to populate data in form What I am wanting to do seems very simple but due to my lack of experience I mu

2017-11-28 18:15:36 +0200 received badge  Editor (source)
2017-11-28 18:15:05 +0200 edited question Using selection to populate data in form

Using selection to populate data in form What I am wanting to do seems very simple but due to my lack of experience I mu

2017-11-28 18:13:52 +0200 asked a question Using selection to populate data in form

Using selection to populate data in form What I am wanting to do seems very simple but due to my lack of experience I mu