As I said I am new to Access and tying to crate this tool for work as way of trying to get to grips with Access. I think I et up the relationship but I think it should Many to Many as any request could have any PCode. There are around 300 doctors in the list which is why I went for separate table (to many for drop won list) an the Pcode is usually provided at the point of enquiry so typing it in and pulling everything else over would be easier for users.
It is very basic first one, just trying to get to grips with some basics (date formatting, pulling data into forms, the history etc) which I could then use for other projects as I learn more.
I have attached a zipped example for you to see what I am tying to do.
Reply With Quote