Search results

now i know to use queries i may be able to get a bit further but havent the time to look now, thanks for your help w0od0o

just had a thought, should the data be coming from a query or directly from the table?

just changed the clientID - invoice table (foreign key) from a combo box to a text box and created a combo box on my form and now theres no data in the combo box (unless i fill in old invoices, then it will select clients i have used in the past), should the combo box on the form be linked from...

not to sure if i need that much info to have 4 tables, its to invoice for an installations company which would issue invoices for the amount of hrs (invoice details) and charged at a set rate (Client details)

if its a text box how will the user know what client to pick? is there not a way of assigning the invoice ID through my "select client" combo box on a new page? w0od0o

gone round in circles all day, i wanted to add new clients ect from another page, ive attached my db if you would mind having a look and hopefully you will see what im trying to do thanks w0od0o

got a bit further i think :S i know have the tables linked, my client table now has a expand button on it which drops down the list of invoices for each client, i have changed my client selector list to pick from the client id in the invoices table which works fine but, click on client, opens...

do i creat a relationship between the 2 tables and the column names? also what would the datatype be for the foreignKey?

sorry really new to this how do i set a foreignkey?

yes a query to create the report would be fine but if i wanted to recall an invoice how would the invoice data know what client i assigned to that invoice if the client data is seperate?

i have created a db with 2 tables, first is clients second is invoices, i have got to a stage where i can select a client from a list which then adds all the client data to another form with the invoice fields/boxes on, my question is.....is there a way of getting all that data into the...

thank you very much, i think i can see what youve done, you have addedd all the other fields to the query? thanks again

im happy to post it here no probs just dont want to take up to much of your time shuld be attached :)

could i send u my db for you to have a sneaky peek? as i think i could get round it but would prefer to do it properly than to cut corners?

right......im getting somewhere but not to fast, although i am learning loads today and i thank you all for your help i have bound the form to my query and i get a wholename drop down now but..........all my other details have change to #Name? so im assuming i have made a boo boo somewhere...

no there is only the field names of the table i originally created the forms with in the dropdown list of control, if i create a new form with just the firstname lastname and wholename fields from the query it works fine am i trying to do something thats impossible or maybe just stupid? is...

not to sure if im getting in a pickle here, =Names.wholename give me the same result, would there need to be an assigned field in a table for the wholename results to be stored? e.g. i have a table with first name and last name (with others, address ect), run the query using those 2, (works...

hi, i am having problems displaying a query in a form, i have created a query to show first and last names in the same text box and called this Names with wholename: Clientdetails.[firstname] & " " & [lastname] in the first blank field query works fine when i run it then ive added a text...

first off link was great ty :) i originally set up a query for the data but then realised that i want all data in that field so i removed it and got the data for the combo box straight from the table, is this not correct? or is it better to always use queries even if they gather all info...

i have created a form with a drop down combo box which looks up my company values in a table but i can not get it to run a query to display the rest of the data for that company, is this the best way to filter some data with a selection list if so could someone please advise a solution to get...