Search results

Minty, allow me a follow up. I did as you proposed, created a query with the fields I would like to include in the lookup. But then I needed to delete the relationship between the tables. Of course the right value will be used but there is no actual relationship between the tables any more! Or...

Thank you GinaWhipp for your reply! My apologise as I have been inarticulate in my explanation. Table 1 (ComboBox) -> Table 2 ID (only) -> Table 3 Name related to ID I would like to lookup information from two tables. Thank you, Thomas

Hi, I am looking for advise on when to a Multiple Primary Key and when a Composite Unique Index shall be used. I created a table with a many to many relationship which I could use Multiple Primary Key or a Composite Unique Index. This table is filled with additional data fields too and not...

Hi, I want to create a lookup field for looking up from a table which itself contains foreign keys but not the values it relates to. Said that I don't want to lookup the foreign keys only but the values the foreign keys are related to in a third table. Thank you, Thomas

Thank you Rabbie! To think to keep it simple need to be learned through experience. Therefor I am happy having a project now. May I ask for advice? I am looking for help regarding Lookup fields and Multiple Primary Keys. Where shall I place my questions? Thomas

Hi, I have been a rookie to Access for many many years. I "played around" with Access but I never had a real project. Now I have a real project and my knowledge I gained by "playing around" with Access isn’t much of a help. I learned a lot of basics but I stuck when it gets more challenging...