Search results

Craig.. You are right, I didn't even notice that. That is the old table. Weird. I will sort it out and try what you suggested. Thanks again

I can post more if needed. But I am hoping you can see what I am doing wrong...

I am attaching some screen shots. The first one with three tables I can see information. The second one with all the tables involved, no informatin is being produced. Thanks again

Craig.. I am having a little trouble building the query that will be the bases for a form. Do I need to create seperate queries based on the info? Here is what I am looking to do.. Tab 1 on the form: event info Tab 2 personnel assigned to said event Tab 3 Ethnicity break down...

Gotcha. Thanks again.

Craig.. One more question. When I do a query, do I need to include the junction tables?

Yeah I know.......... I don't look forward to that lol..

Thank you very much again! Really help full....

Yeah I know.. I took over this database and some of the naming is well.... just flat out bad. I would change it, but there are like 6 or 7 other forms and numerous reports that are based off it.... nice huh..

Craig.. Something like this? See attached. Thanks again for your help!

Craig.. Thank you very much. Question, how do you know when to use a junction table? I have seen it a couple of times but never on when to you use one? Thanks

Craig.. Thank you very much... What I was thinking and what the end user wanted to see was this: Event 1 Event Ethnicity Amarican Indian Male 23 Event Ethnicity American Indian Female 2 Event Ethnicity Hispanic Male 44 Event Ethnicity Hispanic Female 0 Etc Personnel assigned to Event 1...

Hello.. Here is what I have. The database is made up of three tables (see below and see attachment). I have it set as one event to many ethnicity's and many personnel with the event ID as the PK in all three. Did I do this correctly? I thought I did and I had a form with each one of these...

Not to jump off... but I like filemaker..... it is freaking easy to use......... :-)

No mapped drives...... yet.. and thank you very much for the info... I was hoping there wasn't much more I needed to do!

Perfect... I was hoping you would say that!

So there is nothing that I really need to enable etc..... Thank you!

Hello.. I am new to split database format... If I put the backend on say windows server 2000 or 2003 in a folder, is there anything else I need to do? Any setting on the server?? Or do I need a specific type of server os ie sql server etc? Thanks

If you have one set up over a network and you have the compact and repair on close? What effects would one see on the db? Or will it even do it?

Have you seen this happen with someone who is using runtime 2000 with a database built in 2003? I think that might be one of the problems.... I think..