FileMaker: Help with multiple records for 1 table

$10-30 USD

Imefungwa

Imechapishwa

over 5 years ago

$10-30 USD

Kulipwa wakati wa kufikishwa

We are creating a FM database to keep records against assets we support I have created a database with layouts and built relationships I have however reached an issue outlined in the example below We have created a customer list and when we open the customer a list of assets are displayed. For example if we would like to see the details of a clients router we open the router and the router details are displayed. However some clients have two routers and we are unsure how to have FileMaker handle this Ideally we would like to have a button on the router layout to enable us to add another router and have it displayed below the current one. We would like to know how to do this in the future As we will similar scenarios for different assets. If someone could show us how to achieve this that would be great! Thanks Jonny

FileMaker

Kitambulisho cha mradi: 18509395

Kuhusu mradi

9 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

9 wafanyakazi huru wana zabuni kwa wastani $36 USD kwa kazi hii

@AlexBarattieri

The best way to handle this type of situation would be to create a new related table with the asset. From your post, it looks like instead that the "router" info is written in a field of the customer table. Using a table for assets will require some more time but will save a lot of time and give much more flexibility in the future. The info above should be enough for you to complete the job. But I would be happy to work on it if you need... Alex

$40 USD ndani ya siku 2

4.8

(29 hakiki)

6.4

@ausprofreelancer

Hello I have over 28 years extensive experience with Filemaker Pro and have developed, deployed and maintained many instances from very large and complex down through to small more simple deployments. Regarding the Customer -> Router solution, this is doable and depending on how your current solution is developed, would dictate the time required to complete the project. If you would like to send through some additional information on your project and perhaps a copy (cloned/sanitised if required) of your current database, I can review it for you and get back to you with a plan to complete the project and provide a more accurate timeline/costings for completion. Thank you Darren

$88 USD ndani ya siku 1

4.8

(10 hakiki)

5.6

@MartinLuxford

I am an experienced FileMaker developer with over 12 years experience developing applications ranging from complex CRM/ERP systems to Website Content Management systems and mobile solutions. Therefore your request would be relatively straight forward. The following should give you an idea of the database solutions I have developed. The CRM/ERP systems include the development of Invoicing, Quotes,Sales Orders,Stock Control, Suppliers Invoicing and Purchasing and Work Orders modules and in some instance the Work Order (Jobs) module was also used as part of a graphical Scheduling tool using the native FileMaker Webviewer. Also in the course of these developments I have built functionality that integrates the FileMaker solutions with QuickBooks and a Sage utility which is used to export client, Suppliers and financial data directly into Sage and Quickbooks. If you award me this project I can setup an online screen share with you to demonstrate how to carry out your request. Regards Martin

$30 USD ndani ya siku 1

5.0

(2 hakiki)

3.8

@intelligentdb

Hello. I hope my 30 years of experience with FileMaker custom development can be of assistance to you here. I would be happy to talk to you and describe what you need to do as far as restructuring the database to accommodate multiple pieces of equipment.

$30 USD ndani ya siku 1

5.0

(1 hakiki)

1.8

@twelvetens

Hi Jonny, What you're after here is a relational database join. I can explain the concept of this to you fairly simply. Let me know if that's of interest. All the best, James.

$25 USD ndani ya siku 1