I recently added a field to an existing table, and shortly began receiving "Field '(fieldName)' cannot be a zero-length string" error messages for various...

I am experienceing another problem with my replicated BE. Last Tuesday things were working fine, but Friday one of the tables that we query for information...

Hello: I am developing a table now. Whenever I saved my table, it shows "Property value is too large" and I could not save it. I checked all my field and...

Is there a mask I can set to make sure the email address corresponds to the proper format?

I'm trying to design some tables for a simple booking system for school rooms. I'm having some problems with trying to come up with a workable design. In...

What kind of table design should I think about for calculating employee overtime? I am designing an office cost analysis db. Obviously part of this cost is...

Hi, I'm developing a courier appln which contains the customer rates different for each customer. i need to fetch the customer rates from the db. Each and...

I am trying to design a database to store information on products that will need to be output into varoious print catalogs. Here is my starting...

Dear all, Please help me how to design table for FIFO method calculation. Thanks. Regards, Vensia

I have an Inventory table that has many basic attributes such as Id, description, Price1, Price2, Price3, category, etc. The model is now changing and I want...

I have a project where I need to maintain an operating permit for a client. The permit has the following format: Process 1 - Engines System 1 - Emergency...

My facility has an air quality permit that lists equipment, the regulations that the equipment is subject to, conditions that apply to that equipment, and the...

I need to create a report in a database that resembles a spreadsheet. Heres the basic layout - rows for skills, training, etc. descriptions and columns for...

Hi guys, I was wondering if someone could help me a bit here. Im trying to desing an electronic register system for a school. In terms of the table design, I...

Here is an absolutely minimal spec for my little time management system: 1) A set of projects. Each project has a set of tasks. 2) Every day, I make a number...

Can anyone give me some advice on designing a table structure that can represent joint accounts in a donor/donation database for a small college? The...

I'd appreciate any thoughts on optimum design for the following situation. I need to store data relating to periods of activity of a counter device (counts...

I can best describe my problem with an example. I have a form which asks a question and expects an answer of yes or no. I know I can validate the answer by...

Hello all I need some help in designing tables so I wont have problems doing finals reports Background: Compressor manager interface. An interface that will...

Hi All, I am working on an exercise for school but am stuck on a particular point in the table design and wondering if someone might help out and clarify for...