Reply to thread

Message: [QUOTE="NoÃ«lla GabriÃ«l, post: 13207647"] Hi, simply create 2 extra tables, a lookup table similar to: tlkpPhonetypes ------------------- fields: ptID (autonumber) = PK; ptDescription (text) = Business, private, mobile, ..... and a link table to link the persons to their phone numbers like: tblPersonsPhoneNr -------------------- fields: ppnID (autonumber) = PK; ppnPerson (long integer or same filed type as the PK of your persons table) = FK to your table persons; ppnPhoneType (long integer) = FK to tlkpPhonetypes.ptID; ppnPhoneNr (text): the field containing the actual phone nr if usefull you can add a remarks field where you can note things like: "only use this number from 9 to 5 " Hope this helps a bit [/QUOTE]