Search results

cheers for the answer, i did do that but i was wondering instead of having a subform could i not have two set of addresses text box? for example: Type, houseNo, street... Type, houseNo, street and possibly Type in one set fixed to HOME and in the other it is fixed to TERM (there can only...

I have no idea if i did anything but I have about 5 fields in a table which are doing a look up from 5 different tables. They were all working before but now only one of them is working! In the other ones not working, when i try to use combo box, it appears empty however if i hover over the...

would that query also help me to ADD info or just to view info? because if I want to add via form through that query, the query wont return any result?

If i have 3 tables: personal(id,...) link(id,addressId,type) address(addressId,...) Now when I select all these fields and create a form I get one set of address details but i really want TWO! I can use "field list" in design mode and duplicate address related fields but how would access store...

They do belong together because if a user uses my website, they will have a password, option to opt in/out of a newsletter and similar to showing their cv.. The point I was trying to make is if you have some "attributes" that all depend on one thing i.e. ID, is it appropriate to still split...

Ok from a normalisation point my table is Ok i.e. only has fields that depend on the primaryId! but there are so many rows that I was thinking if i should separate the table? for example: details(id, fn, ln, addressId, dob, tel, mob, email, password, newsletter, showCV, workType, contractType...

How would I go and do this? I have 1 solution but wanted some hints/check if I am on right path To have two fields: Id, RefId... Id will be autonumber, in the form using macro/VBA (or even manually) I could copy ID value into RefId appending a letter in front?

OK on simple joins, I use queries to link tables and then build forms so that users can add data etc. However I am having trouble doing this for complex relationships! I have: Personal(Id, name) personal_Address(Id, addressId, type) Address(addressId, .... ) Institution(InsId, name...