Really cool framework. Need a little help though.

[effgee]

I've been struggling with Filemaker for some time but its non intuitive and non standard SQL syntax really kept me from progressing.

I have made alot of progress with Xataface but I still am really confused on how to progress.
I've used the basic layout to accomplish related tables and insert sample data and display related records, but I am unable to progress from here.

I have a very simple application.

I have a Product.
Each product has many synths.
Each synth has many steps.
Each step has instructions and related materials per step.

How can I change this from editing each record, to a more "app" like interface.

My code can be downloaded from here. (8kb) sql included.
http://www.mediafire.com/?sharekey=6995 ... f6e8ebb871

I have more features to add in the future, but I cannot seem to get past this block.

[shannah]

What do you mean by "more of an app"? You have a few options for optimizing the workflow. If you can describe how you would have set it up to work in Filemaker, I may be able to suggest a Xataface configuration that will be comparable.

[effgee]

Steve,

Cool, I will get back to you in a little. Time constraint issues.

Once again..
Just wanted to say awesome job with this framework.
It its very useful, and easy to work with.
In fact I haven't found anything else quite like it.

[effgee]

Here is an example of what I am thinking of.
I didn't have the time to do it in Filemaker, but here is a HTML mockup.

There are a few things missing from the SQL that I uploaded regarding information presented in the layout/template.

Such as, Material_Amount, Material_unit, Step_Time, Step_Title

But the general idea is there.

[shannah]

To get it looking exactly like this you would need to create a custom action. It wouldn't be all that difficult.

You can get a similar effect by simply creating relationships from:
Products to Synths
Synths to steps

In the synths table you would use the grid widget to be able to edit the steps directly in the edit form.

It would provide all the same functionality and with *almost* the same steps.