:?: Not sure if this is correct thread area but here goes.

I have a database table called Prop Ref which hold Property Ref number, house number and street. I want to create a form for staff to input the property ref number and the information held against that number in the prop ref table together with new data from the form is held as a new record in another tanle called Work Req.

I'm not sure how to set this up or if it can be done. Can anyone help. :?:



Steve