Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Best way to approach? (2000)

    I have a table called tblAdvertising that is linked to tblProperty by the primary key field in tblproperty.

    I want to be able to display the contents of tbl property in a continuous form with a date in the header and a command button. By the side of all of the properties listed I want to have a field linked to tblAdvertType which is a single field drop down. I would then select the type of advert for that property.

    Not all the properties would have an advert type, as some will not be advertised that week. The date in the header would be used as the 'advertdate' in the 'tblAdvertising' table and the command button would create a record in the tblAdvertising for the AdvertDate, PropertyID, AdvertType. I can do this on a line by line basis, but don't know how to do it collectively?
    Best Regards,

    Luke

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Best way to approach? (2000)

    Luke

    Without seeing what you have already, I reckon there should be a many to many relationship between your tblAdvertising and tblProperty. I don't how your company does it your end but from experience I sometimes get a newspaper that has a page full of properties in one advert. So one advert can have many properties and a property can be in many adverts. The date of the advert could be selected from a calendar control set in the main form.

    If I deal with multi criteria I sometimes go down the road of seperating out the questions to have, say in your example, a form that has the property as the master form with a subform that stipulates the dates and types of advert that it is in for that period which in turn has a field connected to a lok up table that you can select the advert type. Instead of all the data being shown on a form, have control buttons that open specific queries or reports for that property. It keeps the screen uncluttered.
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •