Search results

I have now worked through all of the relationships on my database, and i think every table is now properly related, so to the best of my knowledge the basic structure should be good, so I am now starting to work on the data input/form. Hopefully this will seem simpler than where I started! I...

I will have to allow for the nature of relationship to more than one of the given reasons. I have made tblNatureOfRelationship, holding 4 possible options. Should I then link pkNatureOfRelationshipID to fkNatureOfRelationship in tblStaffInstitutions?

Updated tables and relationships attached. There is currently no 'natureofrelationship' part, do I add a fkNatureOfRelationship to tblStaffInstitutions, with a field for each piece of information? I am trying to stay away from making forms as you said, but I am just intrigued as to how data...

When a person is linked to a country the data I need is as follows: Name - Joe Link 1 - Sydney Uni, Sydney, Australia, Nature of relationship (4options), Contact link & position, 3 x notes fields. Link 2 - Florida Uni, Florida, USA,.... Each staff member will only be linked with an...

Thank you for taking the time to look at it, very much appreciated, and thanks for clearing up the relationships, now they look much more manageable! Now I understand better how it should operate, but when I look to make it possible to enter the related information for each staff members'...

Latest version should be attached, as you'll see the form "table and subform" has the space for staff data entry, and the subform for country entry, but returns an error when you enter a country, but clear tblStaffCountry and reopen Form "Table and Subform" and it should be ok again. Thanks again

I have had to leave the extra info yes/no options for now because although I need it I cant get past the country entry problem. I've tracked the error message back to any entry in my subform. If I try and make a new staff record, it is all fine with the information and multiple country entry...

I have created a form to enter staff information, and a subform with it linking to the tblStaffCountry, but then I tried to add 4 more fields to tblStaffCountry to store yes/no options for each country (Research Yes/No, Study abroad Yes/No, Employability Yes/No, Recruitment Yes/No), but when I...

Thanks jzwp22! I had posted another message with lots of questions, but after posting I spent a good few hours playing with the database and had a bit of a breakthrough - based exactly on what you said, it just came down to me still not quite understanding! Steep learning curve! The tables...

Hi All, I have been self-teaching access for about 2 weeks now, but am a bit stuck now on how to make things work! Basically I am making a staff database, recording personal staff details, and multiple companies they have previously had involvement with. It feels like I need multiple rows...