• I have two tables:
    Clubs which have a single name in the them ‘Bury’ ‘Stockport’ etc
    the second table ‘Players’ that play at each club
    I want to be able to select the club and then have all the players who play at that club displayed.
    the players file is simply ‘Club’ ‘Player’ ‘Handicap’

    Im sure its simple to link these together and display the lists but Im not very technical.
    Ice managed to create the tables and display them using shortcodes but the linking together is beyond me. Any help would be much appreciated maybe there is an example already for this type of thing.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @pocketpete,

    Can you give me some background info about your use case? Are you looking for a data entry solution? Or a read only publication? On a public web page? Of in your admin dashboard? What is the purpose of the list?

    Thanks,
    Peter

    Thread Starter pocketpete

    (@pocketpete)

    Im not particularly technical. many years ago I used to do a little visual basic stuff with access which is not that much removed from modern sql stuff.

    Many years vb I wrote an app which allow people to select a list of clubs in a league from a drop down list (combo box) these were sorted into alpabetic order.

    A club was selected from the list and below the combo box in a table/grid appeared all the players who played at the club with all their detail match wins etc.

    in this case there were 12 clubs each assigned a number 1-12 (the names were used in the drop down combo box)

    once a club was select I excecuted an small SQL statement to pick up the players details.

    Select * from players where club-id = what ever number they selected in the box

    The players data was then displayed in the grid/table below the combo box.

    ———————————————————————

    As Iam looking at the support forum writing this on my right i can see a ‘Report this topic for’ dropdown with a button underneath for reporting a topic violations etc.
    my request is similar once a topic is selected the sql is selected.

    I know the table has a search facility but it would save having to type the full name in the search this is a problem when you have for example we may have two clubs at the same venue.

    Castleton A team
    Castleton B Team

    you would have to type the full name to get a result.

    You program is the closest thing i have found to my needs. Im sure if I have time I could learn php and manage eventually to create a sql front end that allows me to do this. Basically I want a relational database that can be embedded in wordpress rather than a separate thing. Considering wordpress is a sql database there are very few programs/plugins which allow you to store your own data and perform complex tasks with the data.

    in my case all my data comes from a 15 year old access database linked to vb4 which produces all the league results and i can pop these onto my wordpress site either in a spreadsheet and embed it or in csv and import it straight in using your program. I just need a better method of finding the data.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @pocketpete,

    Hoping I understand your requirements correctly, I think you need a master – detail page. Such a page allows you to manage the relationship between clubs and players tables. There is a video tutorial that explains how to built a master – detail page here:
    https://wpdataaccess.com/docs/documentation/data-projects/one-to-many-relationships/

    The tutorial uses the tables dept and emp. If you follow the tutorial pretend that the dept table represents your clubs table and the emp table represents your players table. Just follow the steps and you should have a working master – details page at the end.

    To copy your data from Access to WordPress, you can export your table data from access to csv and import csv from the Data Explorer (see button Import CSV).

    Please let me know if this helps…

    Best regards,
    Peter

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘linked tables’ is closed to new replies.