doctored Posted June 7, 2008 Share Posted June 7, 2008 OK, I'm sure this is a very simple query, but here goes anyway. I'm designing a database to store acupuncture clients. For each client, I want to be able to record a list of treatments that they receive. Most of the time a client will come back weekly for another treatment. At the moment I have a 'main' database of basic client demographics, and a unique identifier that I have made a relationship to in a separate database called 'treatments'. When I want to add a new record to this, I need to enter the client ID# every time. Is there some way (and I'm sure there is) of making the 'treatments' database like a sub-database within each client's record, rather than what feels like a completely separate list? I expect after a couple of weeks tearing my hair out I could finally work this out for myself, but hair is at a premium. Quote Link to comment Share on other sites More sharing options...
doctored Posted June 7, 2008 Author Share Posted June 7, 2008 By the way, I seem to be able to do this with 'Bento' ! Quote Link to comment Share on other sites More sharing options...
peterc Posted June 7, 2008 Share Posted June 7, 2008 If I understand you, you have a table with clients and a table with clients and the treatments they have had. I would set a relationship between the two tables, based on the client ID, and allow record to be created via this relationship in the client treatment table. Then, with a portal set up on the client table layout, you could see all the treatments a client had and add more from the same layout. Quote Link to comment Share on other sites More sharing options...
doctored Posted June 7, 2008 Author Share Posted June 7, 2008 That 'portal' word keeps cropping up. I vaguely thought it had something to do with my needs, but kept avoiding it in case it accidentally whisked me through to another dimension at warp factor seven. This would be inconvenient as I have a dental appointment Monday. More explanation on 'portal' would be great, please. In the meantime, I'll 'RTFM' again... Quote Link to comment Share on other sites More sharing options...
peterc Posted June 7, 2008 Share Posted June 7, 2008 A portal is like a window into the other tables, but only in real time and only at warp factor "as fast as I can type"...and it really is what you need. It is a fundamental way that filemaker is able to allow you to see and use data without having to re-enter info like client ID each time. It seems what you are after is simple and if you like and can try and talk (or type) you through it. Can you give me more info on how your database is set up? you can email me if that is easier Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.