Need some work done? Post a Project Today
Attention Scriptlance users, Scriptlance has been acquired by Freelancer.com! Find out more
This is a MYSQL multiuser system where users can post notes (Details) against a list of primary records (Parents) via a C# application run on their individual desktops.
I have a "Parent" table with a integer primary key field and text description field as well as some other fields. I have another "Detail" table that has a second integer key field as well as a reference field back to the first table, a TEXT notes field, and and some other fields (user, timeStamp, etc). Its similar to an Order/LineItems setup. The PK's shown below can be adjusted as per your suggestions.
I need a C# windows application that can scroll through the Parent table (Alerts) and view and make entries (Notes), either insert, update, or delete in the Child Table.
A user should only be able to edit or delete their own notes.
An Apply button should post inserts or updates to the notes table as the case may be.
A timed function should indicate to the user that new parent or detail records are available, and which of the detail records has new inserts or updates.
A refresh button should update the Parent records or the Detail records.
More features may be added as we go.
I can make the parent and detail tables on my MYSQL server available to the developer.
The table specs are:
INT pk (Primary Key)
DATETIME timeStamp [sortable]
VHARCHAR sSymbol [sortable]
VHARCHAR oSymbol [sortable]
[Some other fields, sortable]
INT fk (references the Parent)
DATETIME postTime (or update time as the case may be)
[possibly some other fields]
Additional Project Description:
03/02/2013 at 11:53 PST
A complete specification is now available at
Freelancer.com (formerly GetAFreelancer, Scriptlance and vWorker/Rentacoder) is the world's largest freelancing, outsourcing and crowdsourcing marketplace for small business. Hire freelancers to work in software, writing, data entry and design right through to engineering and the sciences, sales and marketing, and accounting & legal services.
Find freelance jobs and make money online! We have freelance coders, writers, programmers, designers, marketers and more. Getting the best web design, custom programming, professional writing or affordable marketing has never been easier!
© Copyright 2013 Freelancer Technology Pty Limited (ACN 142 189 759)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)