Hi Guys
can you help me with a couple of minor things ive got as i'm a little confused.
I have a form (lostprop_form) that I use to record data which is recording the info correct in a table (tbllostprop). However another form (view_lostprop) ive created to display the data listed by tbllostprop isn't displaying it correctly (see pic 1). The item found is listing the id number and not the actual item. Database2 is the table its pulling from. and database3 is the form to input the data. - Wondered if anyone has suggestions as ive tried everything. Also how do i get the choose site combo box above to sort the list below by station as again tried everything i can think of
Also as the purpose of this database is to record lost property, there are going to be occasions where items are collected and reunited with its owners. Is there a way i can click the relevant one in the list that would take me to the original (lostprop_form) which then adds more information such as a check box to say collected, and a couple of text boxes so the collector/collectee (not sure the right plural) details can be submitted, and then it changes the colour of the entry on view_lostprop so we know that's been collected.
hope you got what I meant
cheers