• Welcome to the LegalBeagles Consumer and Legal Forum. If this is your first visit to LegalBeagles and you need assistance then you can ask a question here;
    Create a Thread
    Please Register to get the most out of the forum. Registration is free and only needs a username and email address.
    Please do not post your full name, reference numbers or any identifiable details on the forum.

Building Survey - First Database

  • Filter
  • Time
  • Show
Clear All
new posts

  • Building Survey - First Database


    I’m trying to build a simple database with two tables. Table 1 is a master report, which I export to a word document, a table 2, a large library/template from which I hope to copy records to table 1 to build a report.
    Table 1 and 2 contain the same fields ‘element’ [e.g. roof, ceiling, floor etc], ‘item’ [a description], ‘works’, ‘task’, ‘priority’.
    I have been able to use DB Popup successfully, and been able to group, so I can pull in the records from table 2 to table 1 once selected.
    The problem is table 2 is huge, and impractical to find the records, so I want to create a form which allows me to select ‘element’ and then filters the possible records from table 2 to allow me to copy to table 1.
    How do I get a filter to apply based on the element?

    Any help will be apprecited.

    I didn't find the right solution from the Internet.

    Video marketing agency

    Thank you.

    Tags: None

  • #2
    This is a forum that helps people with legal problems not developers with technical IT problems.

    You want Stack Overflow my friend.

    My posts here are based on my experience of a variety of life events. I have no formal legal training & if in doubt take professional legal advice or contact CAB. If you follow anything I write here you do so at your own risk & I accept no liability for any loss, costs or other outcomes.

    Private messages are disabled as help is only offered publicly. I do not come on here in the evening, at weekends or on public holidays.


    View our Terms and Conditions

    LegalBeagles Group uses cookies to enhance your browsing experience and to create a secure and effective website. By using this website, you are consenting to such use.To find out more and learn how to manage cookies please read our Cookie and Privacy Policy.

    If you would like to opt in, or out, of receiving news and marketing from LegalBeagles Group Ltd you can amend your settings at any time here.

    If you would like to cancel your registration please Contact Us. We will delete your user details on request, however, any previously posted user content will remain on the site with your username removed and 'Guest' inserted.