Search results

I have the Job table and via a New Job form it's possible to create new job records. Next up is tblBudget and tblBudgetStaff. These two tables are linked via tblBudget.BudgetID -> tblBudgetStaff.BudgetID. I need to figure out how to create the New Budget form so that it not only creates a new...

Thanks Minty I've just tried this on the new job form whereby you can select the client from the dropdown box but it actually populates the job table entry with the client ID which is perfect.

Thanks Minty So it would be possible to populate the StaffID field based on the name or initials selected from the combo box?

Minty Could I ask, on the BudgetStaff table, would it be best practice to have a StaffID field (which would be a foreign key linking back to the Staff table) or to have a StaffReference field, which would instead link back to the StaffReference field in the Staff table - this would contain the...

Many thanks Minty. I think I can see where you are coming from. It's supposed to be a very basic database. Its purpose is to record a client job when it comes in and to record the set number of hours each staff member will have on the particular job. It's currently set up with two main tables...

Lol :D. Couple of screenshots below.

Thanks very much - that's worked great. :) I can now pick a staff member from the dropdown box and their hourly rate is displayed in the Rate box next to their name. I have also got the total text box in place which multiplies their rate by the number of hours. The staff member name and hours...

I got it wrong when I mentioned that the hourly rate would need to be entered into a corresponding field in the Budget table. - Select the staff member from the dropdown - Their specific hourly rate should then appear in a text box next to their name - A third text box next to their houry rate...

Hi all. I was wondering if anyone could help me with this... I have a form based on a table called 'Budget'. The form contains combo boxes which look up a list of staff names via a query. The same query also contains hourly rates for each staff member. What I am trying to achieve is when a...

I figured it out - found the code below after some Googling and adapted it to my tables: SELECT agent_code, ord_date, cust_code FROM orders S WHERE ord_date=( SELECT MAX(ord_date) FROM orders WHERE agent_code = S.agent_code); Thanks for the replies. Much appreciated.

Thanks. I made sure that all the fields in my table matched the details in your code howeverI get a "Syntax error in FROM clause" message when I run the query. Any ideas why? As a test I used just the following details in the query: SELECT StaffTable.Staff, StaffTable.Date, StaffTable.Rate...

I have a query on my Access database which selects the Staff Reference, Hourly Rate and Hourly Rate Effective Date from a Staff table. Each staff member gets a new hourly rate each year and therefore for each staff member there are mutiple rows containing details of the hourly rates for the...

Thanks - I'll give that a go.

I'm having problems trying to figure out what mechanism to use in order to add a row to a particular table whilst maintaining a link to a corresponding record in another table. tblJob New jobs are entered in to this table via a 'New Job' form. Users select a client reference from a dropdown...