Database join, Cascading drop down, Add new

Discussion in 'Community' started by Mono, Jul 19, 2018.

  1. Mono

    Mono New Member

    Level: Community
    Hello

    I'm a newbie to Joomla and Fabrik but trying my hand to see how it worksI want to persevere because Fabrik seems great.

    I have been struggling for a few days now with what I expect is a simple problem.

    I have three tables relating to vehicles 'Tbl_make', 'Tbl_model', 'Tbl_vehicleDetails'.

    'Tbl_make' has fields 'makeId' and 'make'
    'Tbl_model' has fields 'modelId', 'model' and 'makeId'
    'Tbl_vehicleDetails has 'LicencePlate', 'makeId' and 'modelId'

    I have no problems here having used database join and cascading dropdowns works a treat.
    However at data entry of vehicleDetails I need the user to be able to add data to 'Tbl_make' and or 'Tbl_model'.

    At the highest level I can use the add function, but in the cascading dropdown its not available.

    I had then decided to have a selection in the dropdown of "Add new model", when this was selected it would enable a text box to enter the new model. I can't however get my head round the task.

    Or if there is a better way I'd love to hear it?

    Mono
     

Share This Page