Jump to content

Lizzy

Members
  • Content Count

    15
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Lizzy

  • Rank
    novice
  1. Thanks Tusif, I'm not sure the company this is for would allow that the contact lists be passed onto a third party, but I can certainly check into that some more. I'm really just looking for assistance on the script steps, if you could help with that it would be much appreciated. Anyway, post back your email if it's not on your profile and i'll send direct if you are interested in helping out there... Thanks again,
  2. Thanks for the quick reply... I was thinking of something along those lines for the displaying of the address in the contacts layout, but the solution I need for now is how to import multiple excel spreadsheets, so it creates records in the addresses table (but not dup's of the contact names). And then using calc's to filter the most recent address, dependent on a date field. I've about 200 spreadsheets to import... Sorry, my original post wasn't so clear... I'm working on an Events Database, and if we can track where people have lived, we can target them specifically in Marketing for eg: if an event in Melbourne is not full, we can email all contacts who have lived in Melbourne, and let them know there are available places... Even if a contact has moved to Sydney... I'm thinking along these lines... Creating an Address book database that shows all our contacts, and where they have lived, and then all the addresses and who has lived there... This database is not for the end user, its just storage and related data. In the Events database, we show the most recent address dependent on the date of the last event they attended (this way we are sure to know their address is most up to date)... Thanks again...
  3. Lizzy

    solutions wanted Multiple addresses

    Wondering if someone could point me in the right direction of keeping a list of addresses that my contacts have lived at. I've looked at some of the starter solutions, but they only allow for second addresses, or a business and a home address etc... I import from excel as information is given to me, and would like to import it, have FMP find the contact, if their address in the excel spreadsheet is not the same as their existing address in our database then have FMP add the new address as a new record in a addresses table, which is linked via their ContactID... Many thanks in advance... :
  4. Hello to All! I posted this in portals, but in retrospect, its a relationship thing... Any suggestions would be gratefully recieved... With thanks ------------- Hiya... I'm working on an Event's database, that incorporates attendees info, events and the people who organize events. Event teams tend to be fairly static with people repeating roles regularly. As they are an Event team member, they also show up in the attendees table, as they've attended an Event. I'm wanting to display events that individual attendees have been involved with, and the specific role they played... ie, Jane Smith 'ORGANISED' 'EventID' 001 & 'ASSISTED' 'EventID' 002, on the Attendees / Contacts layout. So far I can display through a portal Event Team data, but I want data that specifically and only relates to the individual. I have 2 tables :: Events, Attendees, with two join tables :: Registrations (links Events to Attendees) and EventTeams (links teams to events!). Can this be done through a portal..? The purpose of this is to display the training history of attendees. Thanks
  5. Hiya... I'm working on an Event's database, that incorporates attendees info, events and the people who organize events. Event teams tend to be fairly static with people repeating roles regularly. As they are an Event team member, they also show up in the attendees table, as they've attended an Event. I'm wanting to display events that individual attendees have been involved with, and the specific role they played... ie, Jane Smith 'ORGANISED' 'EventID' 001 & 'ASSISTED' 'EventID' 002, on the Attendees / Contacts layout. So far I can display through a portal Event Team data, but I want data that specifically and only relates to the individual. I have 2 tables :: Events, Attendees, with two join tables :: Registrations (links Events to Attendees) and EventTeams (links teams to events!). Can this be done through a portal..? The purpose of this is to display the training history of attendees. Thanks :confused:
  6. Fenton Fenton! It worked, it worked! Lol! Took a little tweaking, but the skeleton was all there, and thanks to you it's now a one-button process. Yah! Duplicates causing a few issues, but I think that is more on the initial data entry rather than the scripting process. Am onto the EventTeam bit now Thanks again...
  7. The mechanics of assigning the EventID are coming together... I've been tossing with the idea of adding a table especially for the different aspects / member levels to the company, or whether to use a check box to list them, and assign that as a category to the "Attendees" It's not going to work, as one "Attendee" can fall into too many categories. The company basically, have two functions 1) Host events, 2) Train ppl to hold events. The general flow goes like this: "Attendee" goes to an event > they usually do one of two things a) go again don't... If they go again they may go on the "EventTeam". If they go on the "EventTeam", it's as an 'assistant'. The "EventTeam" consists of 2-3 'Facilitators' 2 'Organizers' and 3 'Assistants'... People who decide to become involved at an 'Organisers' level, sometimes join the company to complete the "Training" to become a 'facilitator'. So, if I create a table that holds the Company training/facilitation process somehow (haven't thought that through 100% yet." Add another to hold info on the 'EventTeam", in effect either one of those could be a 'join' table to serve in this, and many other solutions. From a users prospective, the layout to assign an New Event, would contain fields from the "Attendees" table, "Events" table, "EventsTeam" table, which would have to have a relationship to the "Company" table. So one event could potentially be added in it's entirety at one point. Although in reality, events are added first, as the schedule comes out. I need to go back to the drawing board... With the addition of an EventsTeam table, it changes things and I'm sure there are other places this table will function. Thanks heaps, it all helps in the overall functioning...
  8. How do i build a many2many structure join free...? I've not heard that before, what would the benefits be, and what circumstances could it be applied in? Do they contain global fields too lol!
  9. cool! thanks for the replies. Sorry for the vaugity (lizzy-ism), around the original post, Attendees are sometimes in the attendees table as, an 'Organiser' for example, always has been to the Event initially as an attendee. There are always at least 7 duplicate records on every import, as those ppl are the 'team' behind the event. To a maximum of 23 at each event. So, in saying that, duplicates could become an issue. My original post was around the table occurance group. Do I need to create a group designed only for the new layout (i.e.New Event/Registration...) The relationships between them has me a bit puzzled too, as i've not at all worked with global fields, despite extensive reading on the concept of applying one record to all records, it makes my heart skip a beat. I'm ready for the challenge i think Thanks heaps, i guess I was on the right track and probably could have got somewhere similar prior to nailing feet to the floor!
  10. Ok... Isn't there an easier way... lol! My thinking was along the lines of building an import script. I always import from the same file as some of the excel doc's i recieve are ... well rather creative! In the script, window pops up, asks what event ID number the records relate to, and then the event ID is assigned. We have hundreds of events and I'm importing records from 1996...
  11. Hiya, I have two tables, one called "Events" and once called "Attendees", that link through a join table called "Registrations". So far, they are set as many to many in the relationship graph, as many attendees attend an event, and attendees attend many events. That's all working great. I receive a list of Attendees from an Organizer (value list), and import those contacts into the database. I would like to create a layout, and a script to automatically assign the Event they attended to the group of imported Attendees. How do I go about building the Table Occurrence Group on the RG. My primary keys are Attendee ID No, and Event ID No. So far I've not used global fields, but think this is the only way to assign the Event ID to the Attendees. Thanks!
  12. Hiya, I've got three tables; Table 1 is Events & Table 2 is Participants. Table 3 which links them all is Registrations. Using the Missing Manual book, I created this database as a data tunneling interface... Each have portals on the layout. Layout 1 for Events lists in a portal, the people attending the event. Layout 2 shows the Participant details and then lists all events they've been at. On the Participants layout I go go to the related event, and the script is working fine. On the Event layout, I can't go to the related participant record. It comes up with an error saying it's can't run script as the target is not part of a related table. Can anyone help! Thanking you ;)
  13. Lizzy

    serial numbers

    Hi Al, Just wanted to say thanks for the help with the serial numbering, that worked a treat. Amazes me how when I think something is going to be rather complex in FMP, it rarely actually is lol! Cheers ;)
  14. Lizzy

    serial numbers

    Ok! I'll try both suggestions and see how it all works... The database I'm working on atm, is for an organization who are very community orientated. My way of thinking is to have one core database, and then manage individual countries from the main. But alas, it seems that's not going to happen, for company reasons etc... Until now, our serial numbers haven't been an issue, and as a contact is added their number is auto generated. They have recently created an online market place for their community, and the serial number is a core element to managing the accounts for this service. Eventually, they will have the whole database online, but until then we have what we have. As their is a US, OZ & NZ Database, all with duplicate serial numbers, my thinking was to identify them with the addition of letters. Any suggestions for other ways of handling the duplicates...? It's very clear that they at this point, do not want to merge the three databases (it's actually 6, guys, girls, then countries...) Thanks again!
  15. Hi to all, Wondering if anyone can help with an issue I've got with serial numbers. I'm new to databasing so it could be an easy thing... Maybe not! What would the calculation steps be in creating a serial number that included letters as well as numbers, and those letters being the result of information checked in a radio set? For eg... An Australian contact who attended a training event I would like their serial number to be A (for OZ)+ 001 (serial number)+ T (training event). With the result looking like this A001T Thanks... :(
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.